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.