Pass thru query question

[Guest]

I sql you can put in prompts using the & sign. I use these a lot to get data
from Oracle but they do not seem to work when used in a pass thru query. Is
there a way to use prompts in a pass thru query?

 

[John W. Vinson]

Is there a way to use prompts in a pass thru query?

Only by reading the prompts from code (e.g. from a Form or an Inputbox
function call) and explicitly copying them into the SQL of the query. There is
no way for the database engine to which you are passing the query to see the
Access frontend prompt value.

John W. Vinson [MVP]

 

[Aaron Kempf]

passthru has been depecrated

you need to move to Access Data Projects