I can't open the Database, created with UcanAccess, with MS Access 2010

[M. Thorand]

Hi,

I make my first steps with the interesting ucanaccess-project.

First I create a .accdb File from MA Access 2010.
Then I run the Console-Program which comes with the file: UCanAccess-2.0.3-bin.zip

Here I connect with the .accdb file and I create a new table with:
CREATE TABLE test (objectid COUNTER PRIMARY KEY, id text(20));

After that I put in one row:
INSERT INTO test VALUES (1,'TEST');

and I leave the console.

When I open the File with MS Access 2010, I can see the Table ‘test’, but when I try to open the table to show the values, I get the error message:

Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt

Thank you very much for your help!

[Marco Amadei]

Hi Thorand,
this problem has already been reported in the previous thread "JackcessOpenerInterface" (see at the end).
I wasn't able to reproduce it, but I tried to patch it anyway in the 2.0.4.
The user who reported this issue has successfully tested the patch .
So, please, re-try the same SQL statements with the 2.0.4 and let me know your findings.
Cheers Marco

[M. Thorand]

Hello Marco,

thanks a lot for your quick response.
Yes, you are right:
With the new Version 2.0.4, I cant't reproduce the error again.
MS Access now is able to open the created table!

Thank you again for your good work,
Marcus