Error Trapping

[abenitez77]

I call a sql stored procedure from ms access. How can i tell if the sproc failed or ran successfully? Also, is there a way to do error trapping and pass the error to ms access ?

 

[Galaxiom]

Build the error trapping into the stored procedure and pass the outcome back in the return value.