• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.

LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.

LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.

Rate LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

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: 

1. Open the table (tblSourceCode) with the Memo field in "Design view" only.

2. On the View Menu, click Indexes.

3. Click the index for the Memo field (Code), and then delete the index.

====================================================================
STATUS
Microsoft has confirmed this to be 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.