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

View products that this article applies to.

This article was previously published under Q198532

Expand all | Collapse all

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

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