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 2002 application/VBA errors and Jet 4.0 errors. The error numbers can potentially go up to 32767, with user-definable errors from 30000 on.
The code in Listing E.1 creates the data in the upcoming table.
Example E.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 ...