ACC2000: "SQLSTATE=26501 (#-514)" Error Message When You Run a Make-Table Query with a DB2 Database (321002)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q321002
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you run a make-table query against a DB2 database, you may receive the following error message:
ODBC-Call Failed - [IBM][CLI Driver][DB2] SQL0514N The cursor "SQLCURCS297" is not in a prepared state. SQLSTATE=26501 (#-514)

RESOLUTION

To resolve this issue, install the latest version of the Microsoft Data Access Components (MDAC) and the latest update for the Microsoft Jet 4.0 database engine.

To obtain MDAC version 2.7, visit the following Microsoft Universal Data Access Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=b41304ca-874f-421d-8820-182f179779a4&DisplayLang=en

For additional information how to obtain the most recent Microsoft Jet service pack, click the following article number to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine

MORE INFORMATION

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Modification Type:MinorLast Reviewed:1/7/2006
Keywords:kbprb KB321002
©2004 Microsoft Corporation. All rights reserved.