ODBC/Access

[Bensta]

I have developed an application using access as a front-end and SQL server 7.0 as a backend. I am using an ODBC to connect to the backend from the client application.
The client application resides on the network drive, which is accessible by all my users. All users will have to creat a short cut to it from thier workstation. The application can also be used off site.
My question is how can I make sure that users will not have to configure a DSN each time they want to use the application? There are 3 different ODBC's: User DSN, System DSN, and File DSN. Which should I use to create my connection to the database with respect to network? Is one of the 3 is universal. And I don't have to ability to run an installation package since I don't have the develper edition.
Can anyone help me please
Thank you

 

[xlbo]

User DSN refers to the user only. System DSN refers to all users on any one machine. File DSNs can be used by all users who have the same drivers installed. You can see all this info on the ODBC Data Source administrator wizard

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244