Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have been using Access 2000 as a tool created to extract data using querys
that linked to Oracle database. Now, the database has moved to a different
region. How can I update the ODBC from the old database to the new? Or do I
need to go into every query and macro and relink to the new datbase local?
Thanks
 
Have been using Access 2000 as a tool created to extract data using querys
that linked to Oracle database. Now, the database has moved to a different
region. How can I update the ODBC from the old database to the new? Or do I
need to go into every query and macro and relink to the new datbase local?
Thanks
Click to expand...

Tools... Database Utilities... Linked Table Manager.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

MS Oracle ODBC failure in Access 07 3
ODBC--call failed. 2
Query linked to Excel doesn't work 5
Record-Locking remains open after closing 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Extracting Memo Fields in Access 4
Access 2003 not linked to Oracle 11g 3
Linking to ODBC Linked Tables 2

Back
Top