ERROR TRYING TO DELETE RECORD

[netrusher]

I have a corrupt record in a table that I am trying to delete. I keep getting the following error when I try and delete the record: "The search key was not found in any record".

Can anyone help me with this. All I am trying to do is delete this one record

Thanks!

 

[BNPMike]

Have you compacted the database?

 

[PHV]

If a compact/repair don't solve your issue you may consider a maketable query based on your corrupted table excluding the unwanted record.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lancelotnz]

I've had this problem before, I think thread702-318764 might have the answer your looking for.

 

[BaudKarma]

I posted something in that thread that might be relevent if you run into this problem again.


I try not to let my ignorance prevent me from offering a strong opinion.