devxlogo

Change Access Passthrough Query Definition

Change Access Passthrough Query Definition

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   Set dbs=Currentdb()   strQuery=

devx-admin

Share the Post: