Microsoft Access Error Number and Error Description Reference
Luke Chung, President
of FMS, Inc.
Introduction to Error Codes
When an error occurs in your Microsoft Access application, Access
provides an error number and description. If you have error handling in place, the error object (Err) lets you
get the error number (Err.Number) and description (Err.Description). For
instance, Error 11 is for "Division by zero".
If you are building applications for international use, you should
only rely on the error number because the error description is localized
to the language of the Access installation.
List of Microsoft Access Error Numbers and Descriptions
As a resource and reference guide, we've tabulated all the MS Access
error codes from Microsoft Access 2010, 2007, 2003, 2002/XP, and 2000. There
are lots of error numbers.
Error Numbers and Descriptions for Microsoft Access
This is the list of the Error IDs and Error Descriptions for
Microsoft Access 2010 and 2007. Links are also provided for resources to
address some of the errors if you encounter them. These are large pages,
so be patient while they load.
PDF Reports of Microsoft Access Error Lists
Comparison of Error Descriptions among Microsoft Access 2010 through 2000
This is the entire list of Error IDs and Error Descriptions for
Microsoft Access 2010, 2007, 2003, 2002/XP, and 2000. Identical error
descriptions are hidden so you see the Access 2007 ones, plus any
changes over time. Knowing this can be helpful if your users report a
different error description from what you expected based on the version
of Access they are running.
Microsoft Access 2010-2000 Error
Number and Descriptions in an Access database table (312K)