Handling "Not a valid bookmark." error with corrupted records

Question

I have a database that has some corrupted records. When looking at the table within Access the records display with "#Error" in the fields. At the same time a dialog box pops-up with "Not a valid bookmark.". While processing these records in some VBA code I get the same error (error number is 3159). My question is this: How can I detect these corrupted records within VBA? Can I do this without trapping that particular error? Is there a way using SQL that I can delete these records? I tried "compact and repair" and it didn't touch them.

Answer 1

I tried to delete the offending records using VBA without success. The records remained after the code deleted them. I was able to work around this by manually deleting one record and then using "compact and repair". This is what I'll have to do for the customer, I guess. Thanks, everyone.

Answer 2

In the case of corrupted database, IMO, the best solution is to create an new empty database, and import all the objects from the corrupted one.