question

KenHood-6449 avatar image
2 Votes"
KenHood-6449 asked JorgeRodriguezLluva-5170 published

MS Access: Repeated Log-In when using Azure Interactive MFA

Short Version: I have an Azure SQL database for which I use MS Access as the front-end. I have a user who has to enter his MFA credentials over-and-over, each time he pulls from a different table in the database. How do I prevent that?



Long Version...

Due to security concerns with his account being hacked, one of my users had his account changed to require multi-factor authentication.

I've set up an MS Access database that uses this connection string:

ODBC;
SERVER=MyServer;
DRIVER=ODBC Driver 17 for SQL Server;
APP=MyApp;
DATABASE=MyDatabase;
Authentication=ActiveDirectoryInteractive;
UID=MyID@MyDoman

When the user opens the app, it applies the connection string to all of the existing tables in the database. At that point, the user has to enter his credentials. (A screen pops up, asking for his password. Then, he has to accept a text message on his phone to verify his identity.)

Then, if the user navigates forms in the database, each time he changes forms, he has to re-enter his name and password, followed by responding to a text on his phone. Even when he clicks on a dropdown list, he has to do the same thing.

How do I set up my database so that he doesn't have to reinput his name & password and respond to the text every time he accesses a data source?

Thanks,
Hood



office-access-dev
· 3
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.

same issue here

0 Votes 0 ·

same issue here

0 Votes 0 ·

same issue here

0 Votes 0 ·

0 Answers