Passing Paramaters when executing a Stored Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi,
try something like this:
currentproject.activeconnection.execute "spTest 1,2,'param3' "

this will execute spTest and pass it 3 parameters
 
Back
Top