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

• Microsoft OLE DB Provider for Jet, version 3.51
• ActiveX Data Objects (ADO), versions 2.0, 2.1
• Microsoft Data Access Components version 2.0
• Microsoft Visual Basic Professional and Enterprise Editions for Windows, versions 5.0, 6.0
• Microsoft Visual Studio 6.0

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 the following error:

Errors occurred.
Run-time error '-2147217887(80040e21)':

CAUSE

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

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.

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.

Additional query words:

Keywords : kbADO200 kbADO200bug kbADO210 kbDatabase kbJET kbMDAC kbOLEDB200bug kbGrpVBDB kbGrpMDAC kbDSupport kbADO210sp2fix
Version : WINDOWS:2.0,2.1,3.51,5.0,6.0
Platform : WINDOWS
Issue type : kbbug