Passing Parameters in Pass-Through query

G

Guest

I'm trying to create a sql pass through query in Access 2000 conecting to a
SQL Server database. How do I pass a date parameter to the pass-through
query? I've tried creating a custom function in Access but that didn't work.
 
M

[MVP] S.Clark

Open the querydef using VBA, alter the SQL WHERE clause with the desired
parameters, and save the query. Execute the PTQ.
 

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

Pass Through Query - not returning rows 1
Question on Pass-through Query 4
Pass Through Query .sql query 3
Access pass-through query to Oracle 10g stored procedure - results 1
Update pass through query of report recordsource 2
Pass-Through Query Error 1
ODBC Pass-through query with parameter from table 5
query too complex to pass optional parameters 1

Top