Why This Chapter Is Important

Stored procedures are at the heart of any client/server application. This is because, using stored procedures, you can guarantee that processing is completed on the server. Stored procedures have many other benefits as well:

  • Stored procedures help you to separate the client application from the structure of the database.

  • Stored procedures help you to simplify client coding.

  • Stored procedures process at the server (reducing required bandwidth).

  • Stored procedures allow you to create reusable code.

  • Stored procedures allow you to perform error handling at the server.

  • Stored procedures facilitate the security of data.

  • Because stored procedures are precompiled, they execute more quickly.

  • Stored procedures improve the stability ...

Get Alison Balter's Mastering Access 2002 Enterprise Development 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.