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

ID: Q198532

The information in this article applies to:

• ActiveX Data Objects (ADO), versions 2.0, 2.01
• 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
• Microsoft OLE DB Provider for Jet, version 3.51

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.

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.

Additional query words:

Keywords          : kbADO200bug kbJET kbMDAC 
Version           : WINDOWS:2.0,2.01,3.51,5.0,6.0
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: January 8, 1999