Using MS Access ODBC with Azure AD

T West 136 Reputation points
2020-07-06T08:18:04.243+00:00

Hi,

Is it possible to connect our MS Access DB to our Azure SQL Server using ODBC and Azure AD?

Our end users login to their devices using their AD credentials. Is it possible to allow to MS Access DB to authenticate with Azure AD by using the users login details (ie can they connect without being prompted to enter their AD credentials again?)

Any help would be much appreciated.

Thanks,
Tony

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,464 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,651 Reputation points
    2020-07-06T08:19:33.197+00:00

    Hi,

    Microsoft Access is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can ask the experts in the dedicated Microsoft Access forum over here:
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access

    (Please don't forget to accept helpful replies as answer)

    Best regards,
    Leon

    1 person found this answer helpful.
    0 comments