O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

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

The Unbound Form and Stored Procedures

My favorite technique with unbound forms is to use stored procedures to retrieve, insert, update, and delete data. Whereas the first two techniques covered in this chapter include the SQL statements required to manipulate the data, the code in this section simply executes stored procedures that retrieve, insert, update, and delete the data. The process of using stored procedures has the following benefits:

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

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