Prod and Test Connection

[XMan]

I have linked tables to SQL-Server.
I'm working on Test DB and ready to switch to Prod DB.
For me to make production module I have to re-link with Prod DB.
Is there a way for me to connect to whatever database?
Either on Prod or Test with input parameters like pick a DSN?
TIA.

 

[Douglas J. Steele]

If you're using a DSN, you can use code like
http://www.mvps.org/access/tables/tbl0010.htm at "The Access Web".

Personally, I prefer going DSN-less, using code like
http://www.accessmvp.com/djsteele/DSNLessLinks.html

 

[aaron.kempf]

you crazy mvp; he's using ADP not MDB

you should look at the connection code on northwind.adp-- it has a good
example for this