Microsoft Access Error Number and Error Description VBA Reference

Provided by Luke Chung, President of FMS, Inc.

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.

• Microsoft Access 2010 Errors
• Microsoft Access 2007 Errors

PDF Reports of Microsoft Access Error Lists

• Microsoft Access 2010 Error Number and Descriptions (738 K)
• Microsoft Access 2007 Error Number and Descriptions (732 K)

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-2003 Error Number and Descriptions (1.3 MB)
• Microsoft Access 2007-2000 Error Number and Descriptions (1.2 MB)

• Microsoft Access 2010-2000 Error Number and Descriptions in an Access database table (312K)

Additional Resources

• Read our whitepaper on Microsoft Access Error Handling and Debugging (in VBA) for related information on making your MS Access database applications more robust and professional. Also includes information on using the ERL function to trap for line numbers.
• This Microsoft Knowledgebase Article (142138) describes how to address some of the errors: An Explanation of Trappable Errors in Visual Basic for Apps. Their explanation for error 49 is not complete. Read our article on Bad DLL Calling Convention instead.
• Security Patch for Excel Prevents Pasting into Access Tables
• Error between Access 2007 and 2010:
  You cannot save this database in an earlier version format, because it uses features that require the current file format.
• Additional Microsoft Access Help Resources.