Jump: Search:

Free Resources from FMS

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

 

 

 

 

Microsoft Access Error Number and Error Description Reference

by 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 2007, 2003, 2002/XP, and 2000.

There are lots of error numbers. Two lists are available:

Error Numbers and Descriptions for Microsoft Access 2007

This is the list of the 2,687 Error IDs and Error Descriptions for Microsoft Access 2007:

HTML Format (717K)

Microsoft Access 2007 Error Number and Descriptions
110 page PDF Report (732 K)

Comparison of Error Descriptions among Microsoft Access 2007 through 2000

This is the entire list of Error IDs and Error Descriptions for Microsoft Access 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 2007-2000 Error Number and Descriptions
227 page PDF Report (1.2 MB)

Microsoft Access 2007-2000 Error Number and Descriptions in an Access table (257K)

Additional Resources

Main Technical Papers Page

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © 2010 FMS, Inc., Vienna, Virginia
Celebrating 24 Years of Software Excellence