Access support for .accdb no longer working
Access support for .accdb no longer working
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.
Re: Access support for .accdb no longer working
Hello,
Try to set SpecificOptions DriverVersion to dvAccdb explicitly
Try to set SpecificOptions DriverVersion to dvAccdb explicitly
Code: Select all
UniConnection.SpecificOptions.Values['DriverVersion'] := 'dvAccdb';
Re: Access support for .accdb no longer working
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.".
Re: Access support for .accdb no longer working
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)?
Re: Access support for .accdb no longer working
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.
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.
Re: Access support for .accdb no longer working
Glad to see that you have found the solution. If you have any other questions, feel free to contact us