ODBC--Call Failed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)
 
Back
Top