Recording the UID/PWD for an ODBC-linked SQL Server table

[Algernon83]

I have a database that I would like to link to a SQL server back-end. However, when I use ODBC to connect, the .mdb file does not record the user id and password. This works for me because I can use my NT login, but other people need to use this database that don't have access to the SQL server database. I've tried changing it using the description field under design view/properties and using a macro to change the table's connect property, but neither change is saved. How can I make it record the userid and password so that others can get into the database?

 

[CsaintAZ]

Use a Pass-thru query, and include the user name and password in the ODBC connect string.

 

[cmmrfrds]

Are the other users using an NT trusted connection. If so, see this site on how to set up a DSN Less connection.

http://www.carlprothman.net/Technology/ConnectionStrings/ODBCDSNLess/tabid/90/Default.aspx

You can set up some VBA code to do this. This is actually the easiest way to roll out the app since you will not need to set up ODBC on each of the users PC's.

If you need further help with this post back.