A2K - how to test database corruption without compacting ?

B

Bartek

Hi,

My database is corrupt.

Symptoms?
- I can see 120 records in table X
- but Autoincrement Id for new record is 100
- update gives error "primary index is not unique"

When compacting (and repairing) Access deletes last 20 records WITHOUT ANY
MESSAGE .

So, my conclusion - never use DbEngine.CompactDatabase because you can loose
your data :) without any message.
But also using corrupt database is not ok.

My question:
Is there any way (any tool) to TEST database without using
DbEngine.CompactDatabase ?

bart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to compact/repair because I have it opened 8
Repeat Corruption Of Database File 2
Is this a corrupt database - or is it a different problem? 2
The VBA project in the database is corrup 1
Compact and Repair Advice 14
Access 2007 Compact and Repair 0
Compact and Repair Database? 4
Access 2007: Escape Out of Compacting Corrupts Database - Database1.zip (0/1) 17

Top