Link to home
Create AccountLog in
Avatar of deer777
deer777Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of deer777

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