Access 97 Deleting Record with Error

[Ken Miller]

I have a record in a table that has #Error in every
field. The computer gives me a jet engine error every
time a i try to deal with this record. How can I delete
it anyone have any suggestions???

 

[Ki Yi [MS]]

Hi Ken,

It looks like you corrupted records in a table. Try the steps in the
following article:
ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/default.aspx?scid=kb;EN-US;247771

You can also try exporting the data out to Excel, delete the corrupted
records, and then
import it back into an Access database.

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.