• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

adding error handling to entire db

I have an mdb which badly need error handling added. I found mz tools but it only seems to add it to one procedure at a time.

How could I add error handling to the entire db?
0
Shawn
Asked:
Shawn
  • 3
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
For sure, you will want to take a look at this:

http://www.everythingaccess.com/vbwatchdog.htm
(read my review on the right side)

However, you pretty much will have to manually add error handling to procedures one at a time. Not aware of a tool that would go through and add EH everywhere ... that would be kind of difficult - too many variables to deal with.

mx
0
 
ShawnAuthor Commented:
looks pretty nice. So I would just set up one global handler and leave any EH I already have in place?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"and leave any EH I already have in place?"
Well ... yes.  The GEH will tap into the existing EH automatically.  All errors effectively get routed to the GEH.

It's a sweet system with a LOT of additional functionality.
0
 
ShawnAuthor Commented:
nice. worth the $ then. That should save me a lot of time and help debug.

thanks mx!


...closing this one but have another question or 2 about a refresh crash. I'll post them seperately.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
vbWD is VERY cool ... definitely a time saver.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now