[AccessD] Access and SQL Server - Where is the work done - How Many Rows are Shipped Across the Network

I believe if you are using a pass through query, the heavy lift is done by
SQL.

If you have linked tables and are using regular queries, access does pull
everything over and does the work on the local PC.

D

On Tue, Mar 12, 2013 at 9:12 AM, Brad Marks <BradM at blackforestltd.com>wrote:

> All,
>
> This is just a curiosity question.
>
> Let's say that I have an Access application that obtains data from a SQL
> Server database via ODBC.
>
> There are 1,000,000 rows in one of the SQL Server tables.
>
> There is a query in the Access application that returns 100 rows from this
> table based on the "Where" condition in the query.
>
> I would guess that the "heavy lifting" is being done by the SQL Server
> database box and only 100 rows are shipped back to the Access application
> on the PC.
>
> Is this correct?
>
> Is this always the case, or is it possible that all of the 1,000,000 rows
> are sent back to the Access application depending on the complexity of the
> SQL?
>
> Again, these are just curiosity questions.
>
> Thanks,
> Brad
>