Passing Paramaters when executing a Stored Procedure

G

Guest

I have created a Stored Procedure in my SQL Server database, which has a
couple of parameters. I need to execute the procedure from with the VBA code
of my Access Data Project, using and ADO connection. I have searched the VBA
help file several times but can not find and help or examples of how to pass
the parameters. Has anyone got any examples of which method should be used
to acheive this.
 
A

Alex Dybenko

Hi,
try something like this:
currentproject.activeconnection.execute "spTest 1,2,'param3' "

this will execute spTest and pass it 3 parameters
 

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

Invalid Column Name Sql-Error :Executing a stored procedure 1
How do you pass parameters to a stored procedure 2
How do you call a stored procedure that returns a value? 3
sql stored procedure 1
SQL Server Stored Procedure timeout 3
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Execute Stored Procedure 1
Access 2000 ADO Recordset from Stored Procedure 3

Top