Hi,

15.02.2022 MS has released new ODBC and OLEDB drivers for download.

Caution - Maybe dangerous update - read first

https://accessexperts.com/blog/2022/03/07/new-drivers-for-sql-server-what-you-need-to-know/?utm_source=feedburner&utm_medium=email

MS Info OLEDB (ADO) Download
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Connectionstring Access
Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase; Trusted_Connection=yes;

------

MS Info ODBC (DAO)
https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server

Connectionstring Access
ODBC;DRIVER=ODBC Driver 17 for SQL Server; SERVER=myServerName\theInstanceName; DATABASE=myDatabase; Trusted_Connection=yes;

------

mfg Klaus