Example Apps for Businesses, Schools & Developers Screenshots
Click any image to view a larger version ...
Version 3.2 Updated 15/07/2019 Approx 1.6 MB (zipped)
This was previously posted at Access World Forums in August 2017
The attached database contains details of all VBA errors included in Access 2010.
It was originally supplied by Microsoft at: https://support.microsoft.com/en-us/kb/142138
Unfortunately that page is no longer being updated.
I originally compiled this list of Access VBA error codes whilst creating an error logging system for one of my own applications.
It is also very useful as a reference source for troubleshooting other databases e.g. when responding to posts at various online Access forums
A report is also available but its about 90 pages long so think before you print it!
Clicking the Search the Internet button runs an online search for the selected error
1. The list does NOT include various JET errors which can also arise occasionally
JET errors include numbers such as -2147467259, -2147221233, -2147352567
Several of these are duplicates of VBA error messages
Click to download: Access Error Codes (zipped)
2. Each new version of Access adds a few new error numbers.
To ensure you always have the latest data, you can also create your own error list in VBA.
For all required code, see: List Access Error Codes