Password Change | Linked Table Manager
SQL Server 2008 R2
We are on a shared SQL Server and therefore must use SQL Server authentication (I know, worst practice). I changed the password on the SQL Server. I changed the connection string in the Access client to use the new password. I reconfigured the ODBC DSN to use the new password, tested the connection and it works.The same SQL Server Management Studio, it works fine with the new connection string.
I ran Linked Table Manager, selected All, and after it ran, 9 tables and three views remained checked, and are unavailable - can't open them from Access.
Any Ideas? Thanks a lot in advance.