F. Scott Barker's Microsoft® Access 2000 Power Programming

Appendix C. ACCESS 2000 AND JET 4 ERRORS

Access lets you trap some errors that can occur during program execution. By using the error-trapping commands mentioned in Chapter 7, “Handling Your Errors in Access with VBA,” you can anticipate errors and handle them accordingly.

The following table lists both Access 2000 application/VBA errors (3-481) and Jet 4 errors (3000-3671). The error numbers can potentially go up to 32,767.

To create the data in the upcoming table, the code in Listing C.1 was used.

Listing C.1. Storing All Access and Jet Errors to a Table

Sub CreateErrorTable() Dim cnn As ADODB.Connection Dim rst As New ADODB.Recordset Dim lngCurr As Long Set cnn = CurrentProject.Connection cnn.Execute "Delete * From tblErrors" rst.Open "tblErrors", ...