Can't Delete Row

[liamrowan]

I have a table in which I have been successfully deleting unwanted rows. However, there is one row that Access will not allow me to delete. When trying to delete it, I get an error message: "The Search Key was not found in any record."

I am simply clicking on the left of the row to select the entire row, just as was done with all the other rows that were successfully deleted.

Any ideas how I can get rid of this row?

Thx,

William

 

[jdraw]

Was this table imported from Excel? If it was, this may be helpful
http://www.accessforums.net/import-export-data/search-key-not-found-any-record-1852.html

 

[vbaInet]

It sounds like corruption.

1. Perform a Compact & Repair on your db.
2. Create new database shell and import all your objects into it.
3. Compact & Repair this new database shell and try again in the new db

 

[gemma-the-husky]

adding to the above, you may need to rebuild the table by writing queries to select everything other than the corrupt row - as you may find the corruption prevents you doing "normal" processing with the table.

 

[liamrowan]

The Compact and Repair worked without even having to import objects to a new database. Thanks so much!

 

[vbaInet]

It might still be worth performing those other steps. Compact/Repair doesn't always get rid of all the errors.

Good luck with the rest of your project!