Solved

adding error handling to entire db

Posted on 2013-01-25
5
226 Views
Last Modified: 2013-01-25
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
Comment
Question by:Shawn
  • 3
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 38820910
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
 
LVL 1

Author Comment

by:Shawn
ID: 38820971
looks pretty nice. So I would just set up one global handler and leave any EH I already have in place?
0
 
LVL 75
ID: 38820982
"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
 
LVL 1

Author Comment

by:Shawn
ID: 38820992
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
 
LVL 75
ID: 38821005
vbWD is VERY cool ... definitely a time saver.

mx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question