O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 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 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", ...

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