title: Handling "Not a valid bookmark." error with corrupted records
body: <p>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.</p>