Example Apps for Businesses, Schools & Developers

Version 3.2             First Published 18 Aug 2019             Last Updated 23 Oct 2022               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 troubleshooting other databases e.g. when responding to posts at various online Access forums

Enter or select the error number in the form combo box. For example:


Click the Search the Internet button to do an online search for related information


A report is also available but its about 90 pages long so think before you print it! The report is also available as a PDF (supplied)


You can also raise random errors and display the error information in a message box. For example:


1.   The list does NOT include various JET errors which can also arise occasionally
      JET errors include numbers such as -2147467259, -2147221233, -2147352567
      Several of these are duplicates of VBA error messages

      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

Please use the contact form to let me know whether you found this article / example app useful or if you have any questions.

Colin Riddington           Mendip Data Systems                 Last Updated 23 Oct 2022

Return to Example Databases Page

Return to Top