how do i delete a record without a search key?

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
 
G

Guest

BackUp your MDB.

Did you try Compact and repair to the MDB where the table is located in?
 
G

Guest

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
 

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
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
Query returns 4, not the 2 records that it should.. 3
The Search Key was not found in any record... 0
Search utility 2

Top