Heya everyone,
I recently migrated my Access back end over to an Azure SQL Database. I relined the tables using the ODBC Driver 13 for SQL Server, I did not save the password.
I expected Access to prompt for an SQL login however, the connection fails for other users. Windows authentication is currently not support on Azure SQL, they do support active directory. The server management tool allows for login with integrated active directory, does anyone know of something similar I can do to pass the active directory login info along with the connection?
If not, I could make a form the prompts the user for their domain password and uses the as part of the connection string but I'm not overly familiar with opening a SQL connection in VBA.
Would anyone be able to shed some insight on the best practice here?