Access 2000 crashes on DoCmd.FindRecord

[Rod]

Any idea what may be causing this:

An Access database, 2000 file format, designed using 2003 but running on
Access 2000. To open a form and find a specific record, the following code is
run:

DoCmd.OpenForm "Quote"
DoCmd.GoToControl "QuoteID" ' Contains Record ID
DoCmd.FindRecord Forms!MyQuotes!MyQuotesList_subform!QuoteID <-- CRASH
HAPPENS HERE, DURING SEARCH

Access crashes at the point indicated.

Is there anything about the development having happened in Access 2003
rather than 2000 that may provide a clue as to the cause of this? This crash
occurs on more than one Access 2000 target machine and I am therefore
reasonably confident that it is not the installation.

 

[n00b]

From my experience, a crash in a database when searching in a table usually
means one of the records in the table is corrupt. You will have to visually
identify the bad record in the table by looking at the data. Sometimes you
find impossible dates, sometimes you see #deleted in a field, sometimes you
scroll to the record and it crashes. You could try importing the table into
a fresh empty access database. If it crashes when you import into another
database, you definitely have a corrupt record.

Here's the really bad news, I have never seen compact and repair fix this
type of problem. One thing you can do is try to delete the corrupt record
but this may not work. You may have to manually import the data (skipping
the corrupted record) into a new table and delete the old table. I usually
use copy and paste for this. Highlight the good records before the corrupt
record, paste them, highlight the records after the corrupt record, paste
them. If you have a backup system, you may have to get a working copy of the
database off of tape if all else fails.