Keep up with connection string

[mcnews]

anybody have a good way to keep up with the correct connection string?
several of the access apps i work with use linked ms sql backends.
in this environment we use development, testing, and production
servers.
within the app i have calls to various stored procs within the DBs.
i have been hard-coding the connection string and commenting out the
one i don't need.
is there a way for the app to *know* what the correct string is?
i have a function to relink the tables to the right server that uses a
table for each connection.
is the linked table info stored in some accessible place?

anyway - any good suggestions will be appreciated.

tia,
mcnewsxp

 

[boblarson]

Why not store the connection strings in a table and have an additional
Boolean field that is "Active" and use a Dlookup to select the current active
one.
--
Bob Larson
Access World Forums Super Moderator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[mcnews]

Why not store the connection strings in a table and have an additional
Boolean field that is "Active" and use a Dlookup to select the current active
one.
--

yeah, i thought of that.
i was hoping there was something stored somewhere within the OS or
Access.
will probably go with the table idea.
thanks,
mc

 

[mcnews]

anybody have a good way to keep up with the correct connection string?
several of the access apps i work with use linked ms sql backends.
in this environment we use development, testing, and production
servers.
within the app i have calls to various stored procs within the DBs.
i have been hard-coding the connection string and commenting out the
one i don't need.
is there a way for the app to *know* what the correct string is?
i have a function to relink the tables to the right server that uses a
table for each connection.
is the linked table info stored in some accessible place?

anyway - any good suggestions will be appreciated.

tia,

looks like TableDefs Connect will get me there.