#error - #deleted - No Valid Bookmark??

[Tezdread]

Hi all,

one of the databases at my place has started acting really strange and was wondering if anyone knows what could possibly be wrong?

there's only one big tble holding about 7.5 k records with approx 10 fields

info that was entered yesterday has now been deleted (by access?) and when you scroll down or go down to the end records, all those records that were there yesterday now show either #error or #deleted and then an error popup appears saying "Not Valid Bookmark"

The UID doesn't appear to be working either, i.e it's not incrementing properly?

any ideas?

 

[Pat Hartman]

Sounds like the database is corrupted. Try the compact and repair. If that doesn't work, download the Jet repair utility from the Microsoft download site. If all else fails, you will need to build a new database from scratch. Hopefully, you will be able to import most of the objects and data from the corrupted one.

 

[Tezdread]

Thanks for the advise Pat, wasn't aware of the Jet repair util so will look for that. We had to use a database backup in the end for this issue...