#Deleted - Row will not Delete

[Guest]

Have a rown in a table that contains the value '#Deleted' in every field.
Want to actually delete this row from the table. Tried to delete, it appears
that the row is deleted, I exit the table then open the table back up, and
the row still exists with the value '#Deleted'. Tried to Compact and
Repair.... Still receiveing the same result. How can I remove this row from
the table?????

 

[Allen Browne]

The trick is to replace the table with another table populated the *other*
records in your bad table.

Details:
Recovering from corruption: Some table rows show #Deleted
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted