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=


														Venkat Alladi
														 
														
															
																
																	
																		
																			
																				
																			
																		
																		
																			Submit a Tip
																		
																		
																			
																				
																			
																		
																		
																			Browse "Visual Basic" Tips
																		
																		
																			
																				
																			
																		
																		
																			 Browse All Tips

0 Comments (click to add your comment)

Comment and Contribute