Create error log file for all messages but it must include enough audit info
Perhaps like a sql server log file, create a file of with error messages using err.object properties but the records must include application db, user, date/time, object(access object), module, procedure.
Klaus Oberdalhoff commented
Superb external solution available : Buy Watchdog
Ricardo Lourenço commented
I would be content if err object tells us the proc and the LINE. it would be wonderful
Brent Morris commented
No one @ MS Access Team even looks at this kind of request. WTF!
Twenty five years ago, my work was the care and feeding of mainframes. To this day I miss the log file containing all that went right and especially all that went wrong. I know this is more on the OS side, but within Access why can we not have an error log file, much like the ldb file that comes and goes when a database is "in session". Only, if the error log file is not null, it hangs around (does not get deleted).