Access 2016

[AndrewT]

I am trying to connect to an Access 2016 database file that has the new extension of .accb. I downloaded the Microsoft Access Database Engine 2016 Redistributable and installed it on my computer. I also have Access 2016 installed on my computer.

My connection string is:

Code: Select all

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Myfile.accdb;Persist Security Info=False;

But the error is get back after the DBConnect line is "ERR The database you are trying to open requires a newer version of Microsoft Access".

I have been able to connect MS to mdb files types, but no luck with this. Has anybody had any luck connecting to these new database files types?

AndrewT

[Marcus Tettmar]

There's no issue connecting to .accdb files. You probably don't have the right drivers installed. Make sure you've installed the 32 bit version as well as the 64 bit version.