Error handling in Stored Procedures

[JHausmann]

you could always wrap your stored procedure call with

On Error Resume Next
'call stored procedure here
err.clear
On Error GoTo Error_routine 'or whatever you normally do for VB errors