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
edit delete
are you sure?
asked Dave Hildebrand

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions