M
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
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