Re: Connecting to Oracle from MS Access 97

From: Roy Zolnoski <ulrich_at_ulrichandhelvas.com>
Date: 17 Oct 2002 11:01:43 -0700
Message-ID: <a419c803.0210171001.704f6e59@posting.google.com>

Thanks, very helpful and informative.

We are going to use the Oracle Migration Workbench to create scripts to move the schema to Oracle. My understanding is that the OMW will create tables in Access which provide a "transparent" link between the Access GUI and the Oracle tables.

Did you use this approach to translate the schema from Access to Oracle? Any feedback?

Thanks again.

bdtmike_at_sbcglobal.net (Mike Dwyer) wrote in message news:<3dacce31.12676988_at_news.sf.sbcglobal.net>...
> Roy,
> I just went through a port of my Access 97 app from Jet to Client
> Server (both SQL Server 2000 & Oracle 9i), keeping the front end in
> Access. There you know, there are more ways to skin a cat. It
> depends on how much work you want to do, do you want to preserve your
> existing code, do you opt for more performance, etc.
Received on Thu Oct 17 2002 - 13:01:43 CDT