Code to change all linked tables's Database name

  • Thread starter Thread starter Brent_Fanguy
  • Start date Start date
B

Brent_Fanguy

I need to know if any code exist that will allow me to
change the Database name used in the Connect string of a
linked table.

We have 10 companies, all using the same ERP software
package all with their data housed in Oracle (all with the
exact same tables).

I want to be able to switch from database to database for
a user who is logged on in Access, without having to
manually go to the linked table manager.

Any help is greatly appreciated.

Brent Fanguy
IT-Project Manager
(e-mail address removed)
 
Back
Top