Create SQL Pass through Query Dynamically

[rmcompute]

I have been creating queries dynamically in VBA. Up until now they have all
been Select, Append or Insert. I recently created a SQL Pass through query
through the front-end and now would like to create it dynamically in VBA.
What command(s) tell the system that the sql creates a SQL pass through query
instead of the standard query? I am assuming the properties must be somehow
passed contining the connection information.

 

[Rick Brandt]

I have been creating queries dynamically in VBA. Up until now they have all
been Select, Append or Insert. I recently created a SQL Pass through query
through the front-end and now would like to create it dynamically in VBA.
What command(s) tell the system that the sql creates a SQL pass through query
instead of the standard query? I am assuming the properties must be somehow
passed contining the connection information.

If you supply a connection string to the querydef that will make it a
passthrough.