With the latest release of the OLE DB driver Access developers can now implement Azure multi factor security into their applications, (previously the latest version of SQL Server ODBC was the only supporting the technology), allowing them to run code in VBA that is compatible.

I recommend using the latest ODBC and OLE DB drivers in order to maximize performance of Access with SQL Server. Here is the MSDN article on the release:

ADVERTISING
SQL Server Hosting

https://techcommunity.microsoft.com/t5/SQL-Server/Released-Update-to-Microsoft-OLE-DB-Driver-18-for-SQL-Server/ba-p/916316

New to SQL Server? Get started with a compilation of my best tips here: https://accessexperts.com/starthere-sqlserver-access/