Question Changing SQL user pw causes ODBC connection issues

[EEALLPARTS]

I have a network that I am running with a SQL 2008 R2 server where I want to change the pw on the user associated with a SQL DB that my Access 2003 database accesses. I changed the pw on the SQL user and when I go into the ODBC connection in Admin tools I get a successful connection with the new pw, but when I try to open the Access database that is using this DSN I get an ODBC connection error. I tried relinking the tables with the Link Table Manager, but I still seem to have this issue.


What do I need to do in order to change a SQL user so that the ODBC connection for my Access database works? The SQL DB is running SQL 2008 R2 running on Server 2008 R2 and the client machines are running Access 2003 on Windows XP SP3.

 

[DJkarl]

This happened to me on an older version of SQL server as well, I deleted the DSN and re-created it, that worked for me.

 

[DavidAtWork]

Have you thought of trying to connect/link the tables dynamically at startup, this will allow you to create and use a generic sql user and password in a DSNless connection string thereby negating the need for any ODBC-DSN to be created on on local (or any) machine
David