Re: Microsoft Access migration: Referential Integrity
Posted by: Scott Harmon
Date: June 22, 2005 12:04PM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.