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?

AndrewT
AndrewT
Newbie
 
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
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

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