FMS Site Search

Microsoft Access Error Number and Error Description VBA Reference

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 2016, 2013, 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.