Access Violation using MSAccess 2007 Database File

[johnbitner]

When I try to connect to an Access 2007 (accdb) database file I get an the error 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. EUniError

The code to recreate this is simply:
...
UniConnection1.ProviderName:= 'ACCESS';
UniConnection1.Database:= ExtractFilePath(Application.ExeName)+'database2.accdb';
try
UniConnection1.Connect;
except
on e:exception do
ShowMessage(e.Message+' '+e.ClassName);
end;
...

The database2.accdb file has a single table with just a few records.

[Plash]

The current UniDAC version does not support Access 2007 databases. We will add such support in the next UniDAC build.

[johnbitner]

http://www.devart.com/unidac/compatibility.html

# Microsoft Access
version 95, 97, 2000, 2003, and 2007.

Who didn't test a 2007 file for at least basic functionality before posting this on the compatibility page?

I've reported several issues in the uniDAC related to MSAccess connectivity and I've only been using it a few weeks on a project.

When can we expect that update?

[Plash]

We are planning to release the new UniDAC build this week.

[PascalD2]

I'm having the exact same error message with 3.50.0.14

Is there any known issues about this ?

I'm just using a plain connection and an AccessProvider.

When I save the db as 2003 everything works fine!

Thanks

[AlexP]

Hello,

I can not reproduce the problem.
I have tested it on UniDAC 3.50.0.14, MS Access 2007 (12.0.4518.1014) and connecting to database was successful.
Please specify the exact version of MS Access and send a sample database to alexp*devart*com.