Is is possible to pass parameter in Access sql?

J

jsacksteder

I have a Query which(correctly) requires a parameter when run. If I am
using Access, I get a GUI dialog prompting for input. However, I need
to use this query through an ODBC connection from another program? Is
there a syntax I can use to pass additional named parameters over ODBC?
 
D

Douglas J. Steele

Unfortunately, no you can't. You'll have to dynamically regenerate the SQL
associated with the pass-through query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Pass-through query with parameter from table 5
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access Pass-through Query to SQL Server 7
Pass-Through Query Error 1
Parameter Query help - Not passing parameter? 3
ODBC Pass-Through Queries 2
Access pass-through query to Oracle 10g stored procedure - results 1
Is It Possible To Pass Parameters to A Pass Through Query 2

Top