Technical support and scripting issues
Moderators: Dorian (MJT support), JRL
- Junior Coder
- Posts: 20
- Joined: Thu Sep 17, 2015 6:06 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?
- Site Admin
- Posts: 6911
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
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.