Pass through queries are not a panacea either. The ODBC interface passes any query it can back to the server. If the query is not too complex, and especially if it doesn't have user defined functions in Access the use of Pass through often makes no significant difference to speed.
Issac has understated the importance of this here.
