Passing multiple parameters to Stored Procedure

[Guest]

A Stored Procedure spPermissionsInsert inserts a record into a table and
returns a value @ReturnVal on completion. The Access ADO code used returns
an error that the first parameter (and presumably the subsequent parameters)
has not been specified. Many examples are available for passing single
parameters but not multiple parameters.
1. Where can an example for multiple parameters be found?
2. Is it necessary to declare multiple parameters or can a single parameter
be used and redefined?
3. How do you get the return value?
4. The parameters in SQL Server are BITs. In Access ADO what is the
equivalent type?
Thank you
Terry

 

[Corey-g via AccessMonster.com]

Hi Terry,

I've been looking at this as well and I don't have all the answers, but here
is a link I was just looking at:

http://support.microsoft.com/kb/q176086/

HTH,

Corey