Error in deleted record in table.

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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CEL504" wrote in message
...
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.

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

Cel504

"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CEL504" wrote in message
...
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.