PDA

Click to See Complete Forum and Search --> : Access database query efficiency?


Winla
May 25th, 2000, 10:04 PM
May I ask a fundamental question about Access database query?

I know that when a Access database application make a query
to another Access database through network, the whole
table data are sent to client computer for processing,
that is what desktop database means.

But if I use SQL server as the database and Access data
application makes a pass-through query, what is the dataflow for this case?

Thx a lot

[Edited by Winla on 05-26-2000 at 11:45 AM]

JHausmann
May 26th, 2000, 02:26 AM
The query is run on the server, using server resources, and the _results_ are sent to the client.