developingprogrammer
asked on
what error numbers will CurrentDb.Execute strSQL,dbFailOnError raise?
hey guys,
i'm trying to write an error handler for the rollback of a transaction and instead of writing a generic catch everything error handler, i would like to handle specific errors that will be raised by dbFailOnError.
hrmm from what i read there could be a few / a myriad of errors raised.
does anyone have the list of errors that dbFailOnError could raise?
if not, could you advise me how i can handle the error specifically? thanks guys!! = ))
i'm trying to write an error handler for the rollback of a transaction and instead of writing a generic catch everything error handler, i would like to handle specific errors that will be raised by dbFailOnError.
hrmm from what i read there could be a few / a myriad of errors raised.
does anyone have the list of errors that dbFailOnError could raise?
if not, could you advise me how i can handle the error specifically? thanks guys!! = ))
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ah i see, thanks mx! definitely agree with you that we can try to gear ourselves for the main errors. hrmm, but i think what i'll do is create a sub function for this if it's very critical so i know that all errors raised in the sub function is a result of the things inside the transaction. thanks mx!! = ))