I'm working on an MS Access 2016 database with 20 linked tables. I change the connection from the prod server to the test server. I use the linked manager, the tables use multiple databases and passwords. If I link the first database and the first password and the second database with their password, there are no problems. In both databases, there are two tables that use a different password. Once I have set this password, when I try to open a working spreadsheet, I am prompted to enter the username and password. When I enter the credentials and close the database, after opening the database, I get the prompt to enter the credentials when I try to open a linked table.