Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Error Message: "ODBC Call Failed" with Linked Pervasive.SQL 2000 Tables

ACC2000: Error Message: "ODBC Call Failed" with Linked Pervasive.SQL 2000 Tables

View products that this article applies to.

This article was previously published under Q268453
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

↑ Back to the top

Symptoms

In Microsoft Access 2000, if you run parameter queries that contain one or more linked tables to Pervasive.SQL 2000, you may receive the following error message:
ODBC call failed

↑ Back to the top

Cause

This behavior is caused by a compatibility issue between Access 2000 and Pervasive.SQL 2000.

↑ Back to the top

Resolution

You can work around this behavior by creating an SQL statement and concatenating the parameters before you execute the statement.

↑ Back to the top

References

For more information about creating custom procedures, click Microsoft Access Help on the Help menu, type module, create in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

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.

↑ Back to the top

Keywords: KB268453, kbprb, kbnofix, kberrmsg

↑ Back to the top

Article Info
Article ID : 268453
Revision : 2
Created on : 6/30/2004
Published on : 6/30/2004
Exists online : False
Views : 325