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 or tables.

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
BFanguy@t3ss.com

This article from the Microsoft knowledge base should do it for you:
ACC2000: Procedure to Create Data Sources and Relink ODBC Tables (http://support.microsoft.com/default.aspx?scid=kb;en-us;208295&Product=acc)