Pass-through query

K

Kent J

Hi all,

I have a Pass-through query ("QueryGeneric") that is connected to an
Access-form. The query has the connectstring to SQL-server.

I would like a Click-button to write to this pass-through query a stored
procedure name and a parameter like "sp_test Parameter1"
...and then execute the query.

How can I do this?

Kent J.
 
D

Douglas J. Steele

Dim qdfPassthrough As DAO.QueryDef

Set qdfPassthrough = CurrentDb.QueryDefs("QueryGeneric")
qdfPassthrough.SQL = "exec sp_test " & Parameter1
qdfPassthrough.Execute


Incidentally, you shouldn't prefix your stored procedures with sp_: that has
special meaning to SQL Server.
 

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

SQL pass through query 5
record set for pass through query 1
Create Form Based on Pass Through Query 1
how to pass a parameter to a query base of a query that is the base of a report 0
Pass-through query for sub report 1
Access Invalid bracketing of parameter name 1
Access pass-through query to Oracle 10g stored procedure - results 1
Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1

Top