I'm using jdbc with ucanaccess... When I connect to the database, there is one table that Ucanaccess is not finding... I saw that in debug mode in NetBeans...
Therefore when I try a transaction on that table, I get :
UCAExc:::4.0.3 user lacks privilege or object not found [Name of my table]
I guess everything else works perfectly since when I did a select on another table it worked...
I'm using :
Update
When Opening the database with console.bat ( by the way, this file is located in UcanAccess download folder) I got the follwoing warnings/errors :
WARNING:Looking for usage map at page 9093, but page type is 1
Cannot load procedure Query4 user lacks privilege or object not found: [My Table Name]
Cannot resolve table [My Table Name]
WARNING:Looking for usage map at page 9093, but page type is 1
strongly suggests a damaged database file. Jackcess, the record manager used by UCanAccess, retrieved a page (block) of data from the file expecting it to be tagged as a "usage map" but it was tagged as something else.
The most common solution for a damaged database file is to open it in Access and then do a "Compact and Repair Database" operation on it.