Changing ODBC Linked Table Stored Credentials

[JeffGeorge]

I have a number of databases that use ODBC connections for working with linked tables from a SQL database. The source SQL data has been moved to a new server with new sa credentials. I have updated my local ODBC connections to use this new information. However, when I added numerous tables to the databases I checked the box to save the password so that it wouldn't prompt me or other users every time I wanted to use the Access database. Is there a way in Access to change this stored password? So far I haven't been able to find one.

[PATRICK]

you can relink all the tables using dns-less connection and have it on a module where you are going to make connection into your sql server and pass the password information. basically your front end, when you first open it, you have to call this procedure and until you not close the file, the password and info about your sql server will remain in your section.