Article ID: 302525 - View products that this article applies to.
This article was previously published under Q302525
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file.
In a Microsoft Access database, when you create a Memo field that includes an index or you create a field name that includes the automatically indexed text, you cannot enter the text that includes more than approximately 3450 characters into the field. When you try to enter more text into the field or try to edit the existing data, you receive the following error message:
Run-time error '3709':
The search key not found in any record.
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:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
Steps to reproduce the behavior in Access 2003
Article ID: 302525 - Last Review: April 14, 2007 - Revision: 5.1