Alison Balter's Mastering Access 2002 Enterprise Development

Summary

Not everything can be done via the user interface or using Access queries. Furthermore, although something can be accomplished via the user interface, it is more efficient to use ADO code and stored procedures to accomplish the task at hand. This chapter covered the ins and outs of executing SQL Server stored procedures from the Access front ends that you build. A well-designed Access application will generally include a combination of bound forms, bound reports, and ADO code. The goal is to use Access and bound forms and reports to accomplish those tasks that Access can achieve efficiently. Mass updates and other tasks that involve large numbers of records should be performed using stored procedures.