Dynamic Connection String for ACCESS 2013 Passthru procedure

Access Connection String for Passthru Query

I have an access 2013 front-end that uses pass-thru queries to run SQL Jobs and stored procedures.

I have to manually change these connection strings to move between a test and a production environment

I know i can use VB to run SQL Commands...but that too must be hard coded -- a maintenance nightmare.

Note: SQL Tables can be re-linked quickly using the linked table manager. I'd like to re-link all my passthru queries using the same type of procedure.

0 answers