Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 198532 - Last Review: March 14, 2005 - Revision: 2.2
FIX: ADO: Unable To Update Memo Field > 64K In Access Database
This article was previously published under Q198532
An attempt to update a large (64K or greater) memo field in a client-side
recordset using the Jet 3.51 OLE DB provider results in one of the following
errors:
Errors occurred.
Run-time error '-2147217887(80040e21)':
-or-
Run-time error '-2147217259(80040005)':
Data provider or other service returned an E_FAIL status.
This problem is caused by a bug in the Microsoft OLE DB Provider for Jet
version 3.51.
This problem only occurs when using the Microsoft OLE DB Provider for Jet
version 3.51 and client-side recordsets.
This problem does not occur if you use the Microsoft Access ODBC driver or
a server-side recordset.
Microsoft has confirmed this to be a bug in the Microsoft products listed
at the beginning of this article.
This bug has been fixed in the Microsoft OLE DB Provider for Jet versions 4.0 and later.
APPLIES TO
- Microsoft OLE DB Provider for Jet 3.51
- Microsoft ActiveX Data Objects 2.0
- Microsoft ActiveX Data Objects 2.1
- Microsoft ActiveX Data Objects 2.5
- Microsoft Data Access Components 2.0
- Microsoft Data Access Components 2.5
- Microsoft Visual Basic 5.0 Professional Edition
- Microsoft Visual Basic 6.0 Professional Edition
- Microsoft Visual Basic 5.0 Enterprise Edition
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
| kbado210sp2fix kbbug kbfix kbjet kbmdacnosweep KB198532 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate