ODBC Connection to MS Access 2019 database Topic is solved

[hisrRB57]

Does anybody know what the connectionstring is to an Ms-Access 2019 database.

The connectionstring to an 2002-2003 database seems to work:

Code: Select all

connectionString := "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\test\Documents\test\test.mdb"
db := DBA.DataBaseFactory.OpenDataBase("ADO", connectionString) 

I have:
- windows 64 bits
- Autohotkey 64 bit
- Microsoft Office Professional Plus 2019. Version 2201 (Build 14827.20192 Click-to-Run)
- Microsoft Access Database Engine 2016 running

When I convert a 2002-2003 .mdb file to the latest format is says it is a 2007 formatted file.

[hisrRB57]

I found the connection string myself:

Code: Select all

connectionString := "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\test\Documents\test\test.accdb;Persist Security Info=False;"
db := DBA.DataBaseFactory.OpenDataBase("ADO", connectionString) ; ADO

By using this site:

https://www.connectionstrings.com/access/