Forum Discussion

Jurgen_Geelen's avatar
Jurgen_Geelen
Copper Contributor
Aug 14, 2025

ODBC connection with MFA

Have someone a ODBC connection with MFA working in MS Access? If yes, how did you do it. 

access

2 Replies

  • Tom_van_Stiphout's avatar
    Tom_van_Stiphout
    Iron Contributor
    Aug 14, 2025

    Standard ODBC drivers do not support MFA. The typical scenario where MFA is used is with a REST web service. If that is indeed your scenario, a library such as this one can be used.

    • Jurgen_Geelen's avatar
      Jurgen_Geelen
      Copper Contributor
      Aug 17, 2025

      "ODBC Driver 18 for SQL Server" have an option "With Microsoft Entra ID integrated authentication". This option doesn't support MFA?

       

      I have found that connection with MFA is possible with adodb:

      conn.ConnectionString = "Provider=MSOLEDBSQL;Server=<server_name>.database.windows.net;Database=<database_name>;Authentication=ActiveDirectoryInteractive;User ID=<user_name>"

       

      Have you ever used this connection?

Resources