Sequel Server Connection

[melodyF]

have an Access Database trying to utilize Sequel Server as my back-end. I have set-up a odbc connection, but when a user request data, they have to enter the connection criteria(username & password). How do I code in Access to automatically pass this info. If somebody is currently doing this, is it possible they can send me the code.

Thanks,

 

[FoFa]

Typically part of the connection string contains the userid/password. Check your ODBC connection and see if you can set it in there. Or you can use a DNS less connection and set it as part of the connection string.