O'Reilly logo

F. Scott Barker’s Microsoft Access 2002 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix E. Access 2002 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 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

<LINELENGTH>90</LINELENGTH>
Sub CreateErrorTable() Dim cnn As ADODB.Connection Dim rst As New ADODB.Recordset Dim lngCurr As Long Set cnn = CurrentProject.Connection cnn.Execute "Delete ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required