[AccessD] vbWatchdog error handler

[Gustav Brock]

Hi John

We do accounting and project management applications. That means:

1. Errors is not an option. Thus, everything is carefully tested in-house before published to clients. The few errors we see are usually caused by the environment. For example, we do test the access to the database at launch, but not before every call of a query. If connection is lost during operation, the application will fail but this is so rare that is doesn't pay to do anything more than traditional error handling.

2. Application operators are not "monkeys" typing in the wild or opening and closing windows here and there, but skilled people. But they often need to be guided a little by the application, thus we spend much time building validation and verification of input and data, setting default or suggested values, etc. - this can often take more time than programming the logic. 

Of course, nothing is completely perfect, but issues are typically in the category "unintended behaviour" where the user expects or wishes the application to do something else than it does. This, however, is a level above what an error handler deals with.

This is why I can't see what benefit we would gain from the watchdog.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af John Colby
Sendt: 30. maj 2023 15:55
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] vbWatchdog error handler

Lol, sadly few developers are as perfect as you are Stuart.

On Tue, May 30, 2023 at 3:04 AM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Me too. :)
>
> Error handling should be pro-active.  Untrapped errors that require 
> this sort of framework are an indication of poor design and testing.
> It's just a PITA that the VBA developers have never bothered to 
> implement Try...Catch and you have to resort to IFs and/or the clunky 
> On Error Goto.
>
> In the rare event that a user finds a new way to break the 
> application, they will generally let you know and you can implement a 
> fix.
>
> I can see it being useful during pre-release testing, but not in 
> production.
>
>
> On 30 May 2023 at 5:28, Gustav Brock via AccessD wrote:
>
> > Hi Dan and John
> >
> > I must say, I´ve never understood the need for extensive error 
> > handling. We test our applications very carefully, thus errors are 
> > extremely rare and certainly not happening on a daily basis.
> >
> > /gustav
> >
> > Fra: Daniel Waters<mailto:df.waters at outlook.com>
> > Sendt: 30. maj 2023 02:48
> > Til: Access Developers discussion and problem 
> > solving<mailto:accessd at databaseadvisors.com> Emne: Re: [AccessD] 
> > vbWatchdog error handler
> >
> > Hi John,
> >
> > I used this up until about 5 years ago.  It's an excellent addition, 
> > and much more than worth the money.  Set up a table to store the 
> > error data, create a report that shows that data, and set up a daily 
> > email so you'll know of any errors that occurred yesterday at each 
> > of your customers.  Or you can set up an immediate email for any 
> > error or if a certain type of error occurs.
> >

--
John W. Colby
Colby Consulting
--