Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: ADO: Unable To Update Memo Field > 64K In Access Database


View products that this article applies to.

Symptoms

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.

↑ Back to the top


Cause

This problem is caused by a bug in the Microsoft OLE DB Provider for Jet version 3.51.

↑ Back to the top


Resolution

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.

↑ Back to the top


Status

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.

↑ Back to the top


Keywords: kbado210sp2fix, kbbug, kbfix, kbjet, kbmdacnosweep, KB198532

↑ Back to the top

Article Info
Article ID : 198532
Revision : 4
Created on : 3/14/2005
Published on : 3/14/2005
Exists online : False
Views : 383