How to check for database errors?

Hi,

How can you check for database errors during connection and execution? Does it have anything to do with the Err object?

Thanks
-Peter

Hi,

How can you check for database errors during connection and execution? Does it have anything to do with the Err object?

Thanks
-PeterTry to catch the error number and its description
and use On Error Goto YouRLabel on the top of your Sub/Function

Msgbox err.Number & " " & Err.Description