After migrating an Access database over to SQL, I linked the tables to the Access front-end using ODBC named "DatabaseName.dsn". In SSMS, I set up a login, using all default settings, for each user that would need access. Authentication is over SQL Server, not Windows.
Then on each user's machine, I logged in with the credentials that I set up. After that first time, no one was prompted to enter the password again.
Recently, I had to remove and re-add a table from the SQL database. This change has now caused everyone to be prompted to enter their password every single time they access one page but not another.
In Access, if I hover over each linked table, I see this information:
Table linked to page that doesn't prompt for pw - ODBC;DSN=DatabaseName;UID=Me
Table linked to page that does prompt for pw - ODBC;Driver=ODBC Driver 17 for SQL Server; Server=ServerName
So what do I need to change to have DSN for each linked table?
If you need more info, I can provide it. Thanks.