Hi,

in Vorbereitung auf den neuen SQL Server 2019 hat MS neue ODBC und OLEDB Treiber zum Download bereitgestellt.

In preparation for the new SQL Server 2019, MS has released new ODBC and OLEDB drivers for download.

MS Info OLEDB (ADO)
https://docs.microsoft.com/de-de/sql/connect/oledb/oledb-driver-for-sql-server

Download
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server

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;

------

ADO / DAO Background Article (de Soto)
https://accessexperts.com/blog/2018/09/11/new-sql-server-odbc-and-oledb-driver/

-------------

SSMA

Download newest SSMA Access Version (2020_Sept_30 Vers: 8.14 - incl. Big Int und Filtered Index)
https://aka.ms/ssmaforaccess

Info SSMA - SQL Server Migration Assistant Info - Access
https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017

Whats new in SSMA 8.14

https://docs.microsoft.com/en-us/sql/ssma/access/what-s-new-in-ssma-for-access-accesstosql?redirectedfrom=MSDN&view=sql-server-ver15

If having installed more than one database engine the program may fail

mfg

Klaus