SQL Password change

[lightspirit]

Hello, I have an System DSN ODBC connection to some SQL databases thru
access, and today the password was changed. The problem is all my tables are
linked with the old password, is there an easy way to relink all my tables
to this new password?
The server is set up with sql server authentication.

Thanks in advace

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0010.htm at "The Access
Web".

Alternatively, you might want to go DSN-less. Take a look at
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html for one way to
do this.