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

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, ...

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