ODBC--Call Failed

[Guest]

My Access2000 database has a link to Timberline Precision
4.0 Estimating database table. I can easily append data
from Access into it. From another non-action, Select
query I only wish to view records based upon a form field:
Forms![Reserve]![PrecPhas]

According to MS Article 268453, I need to concatenate my
query parameter statement in order to avoid an odbc--call
failed problem.

My question is, are there SQL characters required other
than my Forms![Reserve]![PrecPhas] needing to be placed
within my query's design view criteria in order to avoid
the call failure?

 

[david epsom dot com dot au]

If you query an ODBC linked table, Jet will attempt to
convert any JET SQL to ODBC standard SQL as required.

If you open an ADO recordset against a database that is
NOT a Jet database, you will have to use SQL as required
by that connection.

(david)