This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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.
Maybe use the application called “Credential Manager” (can be found in Control Panel) and try removing the obsolete saved passwords that look to be related to your case.
Hi @bjensen_Afp , we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
This is a MS Access question, not related to SQL Server.
Please see:
Hi,
should you be forced to use ODBC?
Hi @bjensen_Afp ,
Please refer to Save Password check box is unavailable when you link ODBC tables get the solution, see below:
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.