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.