Exixsting project: no error handling!

[Marcus]

Good morning,
I'm facing hundreds lines of code in an Access 2003 projects in some 45
forms and 15 reports, where error handling is managed only in some parts
thought to be critical.

80% of the project comes unhandled.

What is the best approach to adapt the code for a full managed error
handling?

Are there some tools to automate the error handling, or a project-wide
strategy for default error handling?

Thanks for helping

 

[Stefan Hoffmann]

hi Marcus,

What is the best approach to adapt the code for a full managed error
handling?

This really depends on what you understand by "full managed".

A global error handler like

http://www.fmsinc.com/TPapers/vbacode/Debug.asp#AdvancesErrorHandling

maybe easily used as a code template with MZ-Tools (http://mztools.com)

Are there some tools to automate the error handling, or a project-wide
strategy for default error handling?

There are "real" global solutions like

http://www.everythingaccess.com/simplyvba/globalerrorhandler/installation.htm

but I never used it.


mfG
--> stefan <--

 

[Marcus]

Thanks for answering, great suggestions.
I'll study them and then maybe I'll ask something else....