Error in deleted record in table.

[CEL504]

There is an error in one of the records within a table, as a result none of
the queries can be run. If I select this record and choose delete, it goes
through the process of displaying one record will be deleted. If I open the
table again the record is there again. Any ideas of what is happening and if
there is a way of deleting it this one record.

Many thanks for any help and advice.

 

[Allen Browne]

See the 3rd symptom in this article on recovering from corruption:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[CEL504]

Many thanks for that and I manged to sort it out as a result.

Cel504