Linked tables to Access as a front end

[GSMike]

Is it true that when you link a table to Access that everytime that data is queried, that the entire table is sent over the network to be processed on the client?
Thanks for your help...
MKemp

 

[Christine0701]

Yes and No. If you link to MSAccess and run the query from your computer it will send the entire table back and forth (in otherwords client side processing). However, if you create an internet related application/page on the server, then the server will process the data and return the results to the client (server side processing).

 

[petermeachem]

Are you quite sure about this? If the data is held in Access, then it certainly copies the whole table across the network, but I'm pretty sure that Sql Server does not. I spent quite some time running queries. I've just tried it. When I ask for a single route (it's all to do with lorries!) I get 60k bytes transmitted. If I ask for all routes I get 300k. I get about 60k for 8 records and 80k for 24 records. Whether this has something to do with page size? With Access as a backend, I get the whole table copied over first time, and then no network activity after that cos it's all here by then.