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

CODING FOR MULTIUSER ERROR HANDLING

The main issue to consider with multiuser error handling is that when an error can be retried, such as a locking error, give users a chance to retry it. This can be seen in the centralized error handler created in the VideoApp.mdb database, which is located on the accompanying CD-ROM in the \Examples folder.

Note

The error handler itself, found in the ErrorHandling module, is discussed in Chapter 7, “Handling Your Errors in Access with VBA.”

Listing 22.14 shows the portion of the ap_ErrorHandler function that you're interested in.

Listing 22.14. VideoApp.mdb: Trapping Multiuser Errors

'–– Check to see how this error is to be handled Select Case intHowTohandle Case apExitApplication '–– if quit the application, ...