Connecting to Oracle from MS Access 97

We are migrating an existing MS Access 97 application to an Oracle back end, Access front end (future phases of the project will replace Access entirely). I am trying to determine the method of connecting to the database which will reach the best balance of performance vs. time spent rewriting the existing Access VBA code.

It sounds like these are the three most likely alternatives. Do you have any recommendations or experience with similar applications?

1. MS ODBC driver (as ships with Access)
2. Oracle ODBC driver (requires Net8, we already have the Oracle 7 driver with SQL*Net installed on our workstations - any conflicts with trying to use both versions?)
3. Rewrite the VBA code to use direct ADO connections to the database.

Existing architecture: MS Access 97 front end database with VBA code using DAO, linked tables to a series of back end MS Access 97 databases. MS Excel 97 pivot tables which get data from queries in the Access databases.

Proposed architecture (this phase): MS Access 97 GUI front end with VBA code, linked tables or direct ODBC connection to Oracle 8.1.7 back end database. MS Excel 97 pivot tables which get data from views in the Oracle database. Received on Tue Oct 15 2002 - 17:14:01 CDT