Passing Paramaters when executing a Stored Procedure

A

Axis

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
 
Top