Using a ADO Connection with SQL Stored Procedure

[gavinjb]

Hi,

I am trying to return a value from a stored procedure to access. From what I remember you have to use a command object and define the Input and Output Parameters, but I cant remember how.

The SQl Stored Procedure takes 6 Parameters (1-5 Input and 6 Output), can someone please tell me how in ADO I can call this SP and return the value from the Output Parameter.


Thanks,


Gavin,