Okay,

I know how to send parameters from Access to SQL Server.
Example:

Execute proc_name param1, param2

I am having SQL return an error to me if something fails. I want to report the error to the user in Access. If SQL is passing something back how do I capture it?

Would it be

Execute proc_name param1, param2, err1, err2

If so I must be doing something else wrong because it is not reporting an error.

This is currently an Access97 db with a SQL 2000 backend.