How to check for database errors?

petesmc
12-14-2003, 07:09 PM
Hi,

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

Thanks
-Peter

bvmantos
12-14-2003, 07:15 PM
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

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum