When the SQL SERVER is used as the database, and Access is the front-end application, this tip can help to dynamically change the Access pass through query definition. This enables one to pull necessary data from the server while avoiding redundant network traffic.
Private Sub ChangeQueryDefinition()
Dim dbs as Database
Dim strSQL as String
Dim strQuery as String
Dim strPassthroughQuery as String
Dim qDef as QueryDefinition