We help IT Professionals succeed at work.

Access 2003 mdb loses odbc password for sql server linked tables every time it is opened

dovidf
dovidf used Ask the Experts™
on
I have linked a number of sql server tables to my access mdb and provided the sql server password for the odbc dsn for each.

Every time that I open the mdb, it asks me for the sql password again. How do I get the pasword to stick.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Can you post your DSN (with password set at **** of course)
Top Expert 2016

Commented:
try to follow the steps from this link

http://www.ehow.com/how_4642566_setup-odbc-database-connection.html


see, if you can make the password stick
dovidfCEO

Author

Commented:
dsn info

name - abc
descriiption - abc
server - aserver
sql server authentication selected
onnect to sql server to obtain default settings etc.
login id - xxx
password <empty>
create temporary stored procedures is checked but greyed out
use ansi quoted
use ansi nulls
perform translations for character data
dovidfCEO

Author

Commented:
I created another dsn but I don't see how that would help since it has the same parameters as the original dsn.

Commented:
In the menu titled Link Tables where you select the tables you want to link, ensure that you click the checkbox titled Save Password

Commented:
This is after you build the dsn and you are in your database linking tables
dovidfCEO

Author

Commented:
There is no save the password checkbox
Commented:
Check out the attached Link tables menu screenshot from my copy of Access 2003. I've never seen a copy of Access without this but i've always used the full install
SavePassword.doc

Commented:
Steps: File|Get External Data Source| Link Tables| select your Data Source| check Data Source Name| click OK|SQL Server Login - enter your password click OK|Link Tables menu opens| select your table(s), check the Save Password checkbox and click OK
dovidfCEO

Author

Commented:
This solution solved 2 problems for me. 1 - the request for password and another error that was occurring in the app.

Commented:
cool; have a great day