how do i delete a record without a search key?

's Computer Specifications

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

's Computer Specifications

Have you done a Compact and Repair?
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"BBR" wrote:

> 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

's Computer Specifications

BackUp your MDB.

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

--
\\// Live Long and Prosper \\//
BS"D

"BBR" wrote:

> 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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit/Delete Record in Search Form	Jess	Microsoft Access Forms	1	19th Nov 2008 04:49 AM
how do i delete record of a saved search in outlook 2007?	tryinghard	Microsoft Outlook Discussion	1	21st Jun 2008 07:44 PM
How do I delete an access record that has no "search key' ?	=?Utf-8?B?QnJhZA==?=	Microsoft Access	1	13th Dec 2005 11:24 PM
can't delete record- Access table due to "search key not found"?	=?Utf-8?B?Sy4gU2ltYXM=?=	Microsoft Access	1	18th Nov 2005 05:44 PM
SEARCH KEY WAS NOT FOUND--CAN'T DELETE A RECORD HELP	=?Utf-8?B?cHJvYmxlbXMgd2l0aCBhY2Nlc3MgMjAwMA==?=	Microsoft Outlook Discussion	1	15th Apr 2005 08:35 PM