Connecting to an SQL server using ODBC

[Jahappz]

i have an access database, that has a linked table to an SQL server. and an odbc connection to it. But everytime i start my Access database i get a "Login to SQL" server window where promted for username and password.
Is there anyway i can make it so the users dont have to type the user name and password?

Pliiise pliiis help me =)

 

[NilsC]

I used the solution from: Microsoft Knowledge Base Article - Q159691, Procedure to Create Data Sources and Relink ODBC Tables

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q159691

Hope this is what you are looking for

Nils

PS.
I distribute the "Access frontend" to users that may not have the 'dsn' setup, so to avoid for me to go to each computer creating a dsn, I use the AutoExec macro to run the "CreateODBCLinkedTables()" Function, to add the dsn to their computers and to relink the odbc tables.
DS

 

[Jahappz]

The Ms page didnt help me but your idea with the "autoexec macro " was nice.. thanx!

 

[NilsC]

Did you try to setup an Access test database and use the code to link the table? It refreshes the link and you don't have to login to the SQL database next time you start the Access database.

Nils