Microsoft KB Archive/268453

= ACC2000: Error Message: &quot;ODBC Call Failed&quot; with Linked Pervasive.SQL 2000 Tables =

Article ID: 268453

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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).



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



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



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

