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.
John
shared this idea
4 comments
-
Klaus Oberdalhoff commented
Superb external solution available : Buy Watchdog
http://www.everythingaccess.com/vbwatchdog.asp -
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!
-
KVD
commented
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).