Linked Table Data - Does it travel?

[Meltdown]

In a linked table Access solution where the tables reside on the network, and each user has a front-end on their desktop, does all the data travel over the network to the clients desktop to do the query, or since the backend is Access and it can obviously understand the query, does the backend do the query and just return the resultset?

Thanks

 

[FoFa]

The access engine is not running on the network such as Oracle, SqlServer, etc. so to the access frontend, it just appears as a file on the server (basically). Now access knows how to deal with the "file" and takes advantage of any built in short cuts, like indexes, etc. But if a full table scan is called for, then all the data in that table has to move across the network where the JET engine is running (front end) to determine what is needed. ow Access will hold this data locally (think temp tables) to work on it for the duration of a said query, or recordset life, but that is about it. At least that is my understanding, right, wrong or indifferent

 

[Meltdown]

Thanks for clearing that up FoFa