Not a Valid Bookmark

[ClulessChris]

Please help,
Some records have corrupted in one table of my DB. The DB still opens as does the table but some records read Error#. These records may not be deleted and cause connection issues when accessed by multi users. I've tried compacting / repairing to no avail. I've tried recreating the table structure and copying the 'good' records out with an append qry, again no luck. How can I repair this DB?

Everybody body is somebodys Nutter.

 

[Norris68]

Create a brand new database and import all of your data into it. There are no guarantees it will work, but this is the only solution I have found when a compact/repair won't fix it.

 

[BNPMike]

Don't you just wish you hadn't chosen Jet?

It seems like you've tried the obvious things - repairing and trying to extract uncorrupted data. You now may have no option but to try and print out anything that might indicate what updates had been made and then go back to your last (nightly?) back-up and try and get everyone to re-do their updates.

For those who aren't aware of this, more up-market dbmss like Oracle and MySQL provide journalling - they write logs as well carry out updates. Then you can roll-forward from the most recent checkpoint. I don't think Jet has anything like that.