child table showing #deleted

[richard harris]

strange events are a happening in my database. been running for over 5 years
and first time this has happened.

I dont know the cause as a users has done something

in a child table the entire records fields show as #deleted. i opened the
table and deleted the record. however when i sort the table the next record
is chnaged to show all fields as #deleted.

any ideas on why this is happening and how to fix it and how to prevent it
in the future.

thanks

richard

 

[Allen Browne]

Richard, this sounds like a corrupt record. It's not common, but it does
happen.

If you can't delete this row, the solution is to create another table and
populate it with all the valid records. You can usually do this quite
simply, as long as you don't refer to the bad row in your criteria. Steps
in:
Recovering from corruption - Symptom: Some table rows show #Deleted
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

 

[richard harris]

thanks allen,

ill try this.

regards

richard

Richard, this sounds like a corrupt record. It's not common, but it does
happen.

If you can't delete this row, the solution is to create another table and
populate it with all the valid records. You can usually do this quite
simply, as long as you don't refer to the bad row in your criteria. Steps
in:
Recovering from corruption - Symptom: Some table rows show #Deleted
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted