O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

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

Chapter 12. Finishing the Applicatio

After working so hard to develop an advanced Access application using VBA, it is important to make sure that the application is capable of performing well and handling the number of users you expect. You also want to make sure that the end users are not able to modify the database source code and design without the proper permission. After you have fine-tuned, secured, and tested the application, you are ready to implement the application by distributing it to end users. However, after you distribute the application to end users, your job is still not finished. Access applications need to be backed up and compacted periodically to ensure that they remain in good working order and that they can be recovered from a backup if corruption or deletion occurs.

This chapter covers:

  • Writing applications to handle multiple users

  • Improving actual and perceived performance of the application

  • Using the Performance Analyzer to help improve performance

  • Adding security to prevent unauthorized access or modification

  • Distributing applications to end users

  • Backing up, compacting, and repairing applications

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