Log errors in Microsoft Access with a simple function
Source: Susan Harkins
If you Google "error logging in Microsoft Access," you'll find a number of complex solutions. The process doesn't have to that difficult. Most of us need only a simple function to log specific information about the current error. This download includes a demonstration database and a several .bas module files you can import into any Access database. For a detailed explanation of the error-logging process, see this entry in our Microsoft Office blog.