The search key was not found in any record.-RESOLVED

[bebandit]

I have an Access 2002 database and I can update and delete just fine. I made a new table called hardware. I added two fields (code and pinkgroup). I can insert into these tables but everytime I try to update one I get:

The search key was not found in any record.

I searched the internet and it says that it is probably a corrupted database and that I need tp use compact and repair which I did. I even deletedthe table and made them again. Every time I go to update, I get the same message. HELP...!!!!!!!!

[bebandit]

From MSDN online . . .



quote:
--------------------------------------------------------------------------------

ACC2002: "Run-Time Error '3709'" Error Message When You Enter a Large Amount of Text in a Memo Field That Contains an Index
The information in this article applies to:
Microsoft Access 2002

This article was previously published under Q302525
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS
When you create a Memo field in a Microsoft Access database and create an index on that field (or you create a field name that includes text that is automatically indexed), you can enter only a specific amount of text. Once you reach this limit (approximately 3450 characters), you can enter no more text and you can also not edit the existing data. If you try to do so, you receive the following error message:

Run-time error '3709':


The search key not found in any record.


RESOLUTION
If you must enter a large amount of text in the Memo field, delete the index for the Memo field. To do so follow these steps:
Open the table with the Memo field in Design view.
On the View Menu, click Indexes.
Click the index for the Memo field, and then delete it.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
This behavior does not occur in versions of Microsoft Access before Microsoft Access 2000 because Memo fields could not be indexed in Jet 3.5 and earlier.