Link to another Access DB through ODBC

[mderby]

Hi ,

Currently, I am working on a MS Access application which link back to a MS Access DB through network drive.

I have read some issue in this forum which say that the performance of the application will be better if we use
ODBC to link back to the DB.

I have try that in my application but Access give this error:
' You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database'

I dunno whether I had mixed any steps. An ODBC datasource had been created in my PC.

Any suggestion will be most well welcomed.

Thanks

mderby.

 

[Pat Hartman]

The performance improvements are not obtained via ODBC to an Access table but via ODBC to Oracle, DB2, SQL Server, etc. Besides, I don't think you can use ODBC TO Access FROM within Access. There doesn't seem to be any point since Jet would be processing the ODBC request in any event.

 

[mderby]

Confirmation

Pat,

Thanks for your clarification. Think I will drop
this idea until I upgrade my DB to SQL Server later.



Now I'm satisfied.