Microsoft KB Archive/321002

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

Article ID: 321002

Article Last Modified on 1/7/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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 &quot;SQLCURCS297&quot; 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&amp;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.

Additional query words: prb

Keywords: kbprb KB321002

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.