Re: Microsoft Access migration: Referential Integrity

[Scott Harmon]

Mike,

> Is there a way I can detect the actual size of a
> Memo column? (I mean without selecting all rows
> and check manually ;)

You can actually use Jet functions for this. For example, say your memo field is named 'Description' then you would:

SELECT Max(len(Description)) as Total from tTable;

Of course this is still a little ineffiecent, but hey you usually only convert once. ;-)

> > The only other thing I can think of is a tool
> to
> > port all our forms, reports, and modules to
> > something like Java. ;-)
>
> Well, this is not so easy. But as it is a higly
> requested feature we might come up with something.
> But not this year.

Wow! That would be very cool. I was kinda throwing that out as a joke, but hey it would be very handy!

> Scott, another question. Do you know how one could
> access Access OLE data from Java? I hate Access
> for storing binary data this way. Maybe something
> on Access side that could "convert" the data to
> something readable?

I haven't dealt much with OLE objects in Access, but if we come across anything during our conversion, I will let you know.

Thanks,

Scott.