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
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