Newbie question about the mechanics of access

[ronny]

Hi To you all

I am not really an access developer but recently and access application of a customer of our company was dropped into my lap after i solve a problem in it

So now I am developing in access as well but I am a total newbie in it and still learning

I have a question about the mechanics of access
If I have a query running on a linked table (sql server database)
How does access work does it first bring all the records fro the table from the server to the pc and then execute the sql to filter out the records needed or
Does it execute the query on the server side and just bring the relevant records to the client ?

Thanks

 

[sfreeman@co.mer]

It should be doing all of the query parsing on the server, returning only the resulting dataset.