Solved

adding error handling to entire db

Posted on 2013-01-25
5
223 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 - Access MVP) 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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 …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now