Interactive authentication to Azure SQL Database
I am using Azure SQL Database and the authentication is based on azure active directory two factor authentication. As a foreground, I would like to have an MS Access database to link to SQL database tables and share this database with the client. I have created an ODBC connection in the "Linked Table Manager" like this: DRIVER=ODBC Driver 18 for SQL Server;SERVER=myServer.database.windows.net;APP=Microsoft Office;DATABASE=myDatabase;TrustServerCertificate=Yes; The problem is that when I'm developing forms, the authentication window repeatedly asks for authentication. How can I fix it so that I only authenticate once?
