question

bjensenAfp-6665 avatar image
0 Votes"
bjensenAfp-6665 asked Viorel-1 edited

ODBC password used to save. After updating table, now I'm prompted for pw every single time.

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.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


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.

0 Votes 0 ·

Hi @bjensenAfp-6665, 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.

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SADALI-1584 avatar image
0 Votes"
SADALI-1584 answered

Hi,
should you be forced to use ODBC?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @bjensenAfp-6665,

Please refer to Save Password check box is unavailable when you link ODBC tables get the solution, see below:
79042-access.png

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.



access.png (64.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.