Mendip Data Systems

Database apps for businesses, schools and developers

LogoTransparent

Example Apps for Businesses, Schools & Developers

Version 3.1      Updated 06/03/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 trouble shooting 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 a Google search for the selected error

 

NOTE:

1. The list does NOT include various JET errors which can also arise occasionally

    JET errors include numbers such as -2147467259, -2147221233, -2147352567

 

    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

Access Error Codes

Click any image to view a larger version ...

Screenshots

Return to Example Databases Page AccessErrorCodes ErrorGoogleSearch