#ERROR AND #DELETE

[Guest]

How do I delete a row in a table that has #ERROR or #DELETE? Access replies
no key and won't allow a delete to take place.

 

[Allen Browne]

This occurs when there has been a corruption of the database, and - as you
found - you usually cannot delete the record.

The way to get rid of the bad record is to create a new table, and import
the good records into it. You must not refer to the bad record in your
criteria. Details in the 3rd symptom of:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

 

[Gary]

How do I delete a row in a table that has #ERROR or #DELETE? Access replies
no key and won't allow a delete to take place.

Another way (easier too, IMO) is to just compact and repair the database. In
Access 2000 it's in Tools - Database Utilities - Compact and Repair
Database. Then the bad record will be pulled out into a separate table
called MSysErrors (IIRC) and that can be deleted at a later date if you wish
with no harm to the rest.

HTH,
Gary