Re: Update table from ODBC

The 2 methods should result to the same set of Records appended unless the
criteria are interpreted differently. If you use Pass-Through, the ODBC
server interprets your criteria. If you use linked Table, JET uses
SQLGetInfo and SQLGetTypeInfo to ask the ODBC driver whether the server
supports operators + functions used in your criteria and try to pass as much
as possible to the server. However, there are numerous cases where JET will
actually performs the calculations rather than passing to the server.

If you want, post the SQL Strings of your Pass-Through Query, your Append
Query using the Pass-through and your Append Query using ODBC-linked Table
and others may know why the same criteria in 2 Queries behave differently.

--
HTH
Van T. Dinh
MVP (Access)



"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F65C00CF-180C-45D9-B93F-CED53E9EC1AB@xxxxxxxxxxxxxxxx
>I tried using the pass-through query as the source for a separate append
> query and it worked a treat.
>
> Just for the excercise I also tried ODBC linking the source table in the
> external DB and tried to run the append query from it - but the query
> return
> odd results, it seemed to ignore the criteria that had been set. I
> wondered
> if it was a linking problem, but I am only querying a single table???
>
> Don't know - but the first method worked perfectly
>
> Thanks.
>
>


.

Relevant Pages

  • Re: time criteria in query
    ... Query with Time Criteria Returns No Records from Microsoft SQL ... type I'm using in SQL server? ...
    (microsoft.public.access.queries)
  • Re: Access Query on SQL Linked Tables
    ... Access 97 using linked tables from an SQL Server 2000 machine. ... I've created a simple query using two tables joined by one field ... If you are not familiar with pass-through queries, ...
    (comp.databases.ms-access)
  • Re: Action pass-through with a form variable Access 2003
    ... TblTemp in your local mdb the easiest would be a standard query on the ... doesn't know about your local tables, so no, you cannot append either. ... the easiest way would be to establish a link to the server ... I can run it: It will run the pass-through as pass-through ...
    (comp.databases.ms-access)
  • Re: ODBC linked tables vs. SQL specific passthrough
    ... I have found that running pass-through queries speed ... one query I was using took ... When I used a pass-through query instead, ... The way I understand it is Access goes out to the server ...
    (microsoft.public.access.queries)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)