Changing ODBC password in MS Access

[Alan Munter]

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.

 

[david epsom dot com dot au]

Is there any way to change the password that Access has stored

linked tables permanently short of deleting and relinking the

1) You could use Win2K security (trusted connections).
2) You may be able to REFRESH the links instead of
deleting and re-creating (if you are doing this in
code, it is a small change)

change because then all the relationships go out the window

Relationships defined on linked tables have no effect
anyway do they? Or does this work instead of defining
primary keys?

(david)