Access support for .accdb no longer working

[cbc700]

A prior version of UniDAC worked fine. Now working with 6.3.12 under XE7. I can open a particular .accdb in Access 2013, but trying it with UniDAC (in an app or just with components) does not work. It displays the message "[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt..". Trying it with an .mdb file works fine. Please have a look. Thanks.

[AlexP]

Hello,

Try to set SpecificOptions DriverVersion to dvAccdb explicitly

Code: Select all

  UniConnection.SpecificOptions.Values['DriverVersion'] := 'dvAccdb';

[cbc700]

I'm now using only the components on a form. I had tried your suggestion already -- did not work. I've tried it again -- same. I have now created a new 2013 .accdb file and the same things occurs with that one. The only difference is that when I change the specific option to dvAccdb, the message changes to "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.".

[AlexP]

UniDAC works with MS Access via native ODBC drivers. Please specify what ODBC drivers for MS Access are installed on your PC (names and versions)?

[cbc700]

Thanks. Your mention of that caused me to inspect things a bit, and yes, there are no MS Access ODBC drivers that handle the .accdb format.

There may be more than one solution, but I chose to install the Microsoft Access Database Engine 2010 Redistributable (available in 32 and 64 bit) from https://www.microsoft.com/en-gb/downloa ... x?id=13255. This solved the problem. Thanks.

[AlexP]

Glad to see that you have found the solution. If you have any other questions, feel free to contact us