Can you please help to do database error handling code

to trap errors like duplicate key , Stored procedure not
found errors .error number like 2601,2812.

  thanks
  Suresh.

On Error GoTo errhandler

'
' Add your database code here.
'

Exit Sub

errhandler:

Select Case Err.Number

    Case 2601

    ' Code for error 2601

    Case 2812

    'Code for error 2812

End Select

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)