asked on 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
Microsoft AccessVBASQL
Last Comment
PatHartman
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am using Access 2010
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