Access 2003 mdb loses odbc password for sql server linked tables every time it is opened
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.
Every time that I open the mdb, it asks me for the sql password again. How do I get the pasword to stick.
jerryb30
Can you post your DSN (with password set at **** of course)
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
http://www.ehow.com/how_4642566_setup-odbc-database-connection.html
see, if you can make the password stick
ASKER
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
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
ASKER
I created another dsn but I don't see how that would help since it has the same parameters as the original dsn.
In the menu titled Link Tables where you select the tables you want to link, ensure that you click the checkbox titled Save Password
This is after you build the dsn and you are in your database linking tables
ASKER
There is no save the password checkbox
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
This solution solved 2 problems for me. 1 - the request for password and another error that was occurring in the app.
cool; have a great day