By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

Changing ODBC password in MS Access

P: n/a
I have changed the passwords on our MySQL DB server for a few users.
I went in to the ODBC data sources configuration on their machines and
changed the passwords to the new ones.

However, every time they open the database that contains the linked
tables which use that ODBC data source, instead of using the password
configured in the data source it uses the old password which is saved
in the Access database somewhere. They have to retype the new
password when they try to open any of those linked tables after
starting up Access.

Is there any way to change the password that Access has stored for the
linked tables permanently short of deleting and relinking the tables?
I don't want to delete and relink the tables every time the passwords
change because then all the relationships go out the window as well.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
How about using the Linked Table Manager to do your relinking?
- Turtle

"Alan Munter" <al*********@nist.gov> wrote in message
news:62**************************@posting.google.c om...
I have changed the passwords on our MySQL DB server for a few users.
I went in to the ODBC data sources configuration on their machines and
changed the passwords to the new ones.

However, every time they open the database that contains the linked
tables which use that ODBC data source, instead of using the password
configured in the data source it uses the old password which is saved
in the Access database somewhere. They have to retype the new
password when they try to open any of those linked tables after
starting up Access.

Is there any way to change the password that Access has stored for the
linked tables permanently short of deleting and relinking the tables?
I don't want to delete and relink the tables every time the passwords
change because then all the relationships go out the window as well.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.