split databases and connection settings..

[Guest]

I'm looking to deploy an MDB which contains queries and reports to my clients
users. The queries are setup to use linked tables on an SQL 2005 Server
database and I also use passthrough queries to execute stored procedures.
Since I can't be sure they all have the same DSN setup I'm using can anyone
clue me in as to how this should be done?

Any suggestions would be appreciated.

 

[Rick Brandt]

I'm looking to deploy an MDB which contains queries and reports to my clients
users. The queries are setup to use linked tables on an SQL 2005 Server
database and I also use passthrough queries to execute stored procedures.
Since I can't be sure they all have the same DSN setup I'm using can anyone
clue me in as to how this should be done?

Any suggestions would be appreciated.

You can either have your app create its own DSN or go DSNless.

http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1

 

[Douglas J. Steele]

You can either have your app create its own DSN or go DSNless.

http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1

And http://www.accessmvp.com/DJSteele/DSNLessLinks.html shows how to set up
linked tables using DSN-less connections.