by LaVolpe (66 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Wed 9th May 2001
Date Added: Mon 8th February 2021
Rating: 
(1 Votes)
LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.
VBcoders
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.
No comments have been posted about LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue.. Why not be the first to post a comment about LaVolpe Source Code Repository: Error 3709 resolution to Microsoft acknowledged issue..
