how do i delete a record without a search key?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a corrupted record on an access database. It is on a subtable to my
primary table. I have deleted the record on the primamry table but every
time i try to delete the record on the subtable access brings up an error box
that says "SEARCH KEY WAS NOT FOUND IN ANY RECORD". I would like to just
delete the corroped record. I have tried to just input new data into the
record fields and it brings up the same error message - "SEARCH KEY WAS NOT
FOUNDIN ANY RECORD". Any ideas on how to either delete this corrupted record
or fix it so I can inout new data into its fields???
Thankyou
BBR
 
BackUp your MDB.

Did you try Compact and repair to the MDB where the table is located in?
 
Thanks to all who replied. I completely forgot to even try the companct
function. When i did it fixed my corrupted file and all is good in my
database. Thanks again.
BBR
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DELETE FROM a table WHERE... 1
Record-Locking remains open after closing 0
Guidance required for report design 4
delete child records in subtable when parent record deleted 3
The Search Key was not found in any Record. 2
Error 3201 You can't add or change a record...when delete/deleting 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
Search utility 2

Back
Top