ACCESS ERROR MESSAGING

When an error occurs, by default Access simply displays a description of the error. If you're in the retail version of Access, it gives you the dialog shown in Figure 7.1. In this dialog, choosing Debug causes the VBE to appear; choosing Continue ignores the error; choosing End stops execution. If you are using an application distributed with the runtime product, you're given the option to retry or cancel, and then are dumped to Windows.

Figure 7.1. After you get this error message, Access's default error handler allows you to debug the routine with the VBE.

Using Access's error handling is very straightforward, when you ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.