CODEWITHSUNDEEP
ucanaccess
tom johnes
tom johnes

Reputation: 417

Ucanaccess 4.0.3 cannot find a specific table in my DB

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]

Upvotes: 2

Views: 296

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123779

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.

Upvotes: 3

Related Questions