Access 2016

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Access 2016

Postby 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?

Posts: 18
Joined: Thu Sep 17, 2015 6:06 pm

Re: Access 2016

Postby 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?
User avatar
Marcus Tettmar
Site Admin
Posts: 6807
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK

Return to Technical / Scripting

Who is online

Users browsing this forum: Google [Bot] and 6 guests