Code to change all linked tables's Database name

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
[email protected]
 
Top