G
George
Hi,
my understanding of pass-thru queries is that the SQL
statement is directly passed to the back-end ODBC data
source, without any syntax checking from within Access.
The ODBC data source (such as a SQL Server db on a
designated server) is responsible for processing the query
and returns ONLY the results of the query, but not all
data. Please verify if I am correct.
On the other hand, in a FE/BE (Access) setup, non-pass-
thru queries require the BE (on a server) to return ALL
data from ALL tables mentioned in the SQL statement. This
significantly increases network traffic, especially when
querying against tables with large number of records.
Please verify if I am correct.
Thank you.
my understanding of pass-thru queries is that the SQL
statement is directly passed to the back-end ODBC data
source, without any syntax checking from within Access.
The ODBC data source (such as a SQL Server db on a
designated server) is responsible for processing the query
and returns ONLY the results of the query, but not all
data. Please verify if I am correct.
On the other hand, in a FE/BE (Access) setup, non-pass-
thru queries require the BE (on a server) to return ALL
data from ALL tables mentioned in the SQL statement. This
significantly increases network traffic, especially when
querying against tables with large number of records.
Please verify if I am correct.
Thank you.