Re: Oracle 8i and MS Access 2000?

Assuming you are using the Oracle Migration Assistant:

Most of the conversion is automatic; however, after the migration completes, verify that the data types and macros are converted without problems.

The Oracle Microsoft Access Assitant generates a migration log and report --- view it for and error messages.

There are additional steps, for instance, you should take if you are planning to take advantage of the full capabilties of 8i:

Precompiler applications - You should consider relinking the applications to the SQLLIB runtime library provided by the 8i precompiler before running them against the 8i database.

Hope this helps. Let us know how it worked out for you.

JD

Rene Pijlman <R.Pijlman_at_applinet.nl> wrote in message news:l9597sg43uv8p65be0hr9050eq5q2u6t71_at_4ax.com...
> I'm using an Access 2000 Jet database (don't ask) with a
> Java-application. I'm hitting so many bugs in the JDBC/ODBC-bridge
> that I'm considering moving the data to Oracle 8i.
>
> How well will my Access 2000 application work with Oracle 8i? Should I
> expect lots of bugs and problems, or should it be a smooth migration?
>
> --
> Vriendelijke groet,
> Rene Pijlman <R.Pijlman_at_applinet.nl>
> http://www.leren.nl/ Wil je iets leren op het web?
> http://www.applinet.nl/ Informatiesystemen & Internet
>
Received on Thu Jan 06 2000 - 14:36:15 CST