Access 2016

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
Junior Coder
Posts: 22
Joined: Thu Sep 17, 2015 6:06 pm

Access 2016

Post by AndrewT » Thu Jan 11, 2018 10:29 pm

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?


User avatar
Marcus Tettmar
Site Admin
Posts: 7029
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK

Re: Access 2016

Post by Marcus Tettmar » Mon Jan 15, 2018 5:26 pm

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.
Marcus Tettmar |

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply