Create SQL Pass through Query Dynamically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
rmcompute said:
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.
Click to expand...

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