ODBC Connection to Oracle from MS Access

A

Abhijit

Hi,
I have some Oracle tables linked from MS Access 97 through DSN. When I copy
the MDB file to another PC it loses the connection although the same DSN
existed in the new PC. I have to reconnect to Oracle again from MS Access
again when I open the linked tables in the new PC. Is there any way to
correct this? I am getting the following message on the second PC when I try
to open the linked tables.

ODBC --connection to <Database Name> failed.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Cannot add MS ODBC for Oracle 1
Adding data to MS Access from csv file 0
Table Security in Access 2013 1
Problem activating pre-installed MS Office home and Student 0
Link table from Oracle database 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Oracle Connection String 1
REINSTALLING MS OFFICE PRO PLUS 2019 0

Top