Logging Errors

[kris_]

Hi,



I'm curious if there is a simple way to log errors when a front end file crashes, fails to connect to the backend, or when bugs in my VBA code pop up?

I would like to be able to track any exceptions thrown in general so that I can have a better idea of how well my database solution is performing and where improvements need to be made.

This question is intentionally a bit broad because I'm just starting to explore what kind of error logging options are available. Any suggestions are appreciated!

-K

[orange]

See http://www.cpearson.com/Excel/ErrorHandling.htm
and
http://www.cpearson.com/Excel/DebuggingVBA.aspx

You may also wish to investigate MZTools

[CJ_London]

since you are exploring ideas - look to the bottom of this thread where similar questions have been asked

Also google your question - perhaps something like 'access vba error log' or similar

[isladogs]

A good starting point is the Access crash reporter by the Smiley Coder. See https://thesmileycoder.com/crash-reporter/
I use a similar system but with automatic emails sent 'silently' to the developer with full details of the logged error.