MS Access VBA change connection string of SQL Pass Through Table
Create VBA code that will changes the connection string of the SQL Pass Through table (DB_A) to the sandbox table that gets created by DB_B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The version of Access doesn't affect the connection string. It is the version of the driver and the server that you need to be concerned with. Here is a relinker I made that lets you swap between various production and staging libraries. I used part of the server instance name to define what needed to be swapped. At the end, all the pass-through queries are relinked.
RelinkODBC.accdb
RelinkODBC.accdb
ASKER