Alison Balter’s Mastering Microsoft® Office Access 2007 Development

Chapter 26. Creating Your Own Libraries

IN THIS CHAPTER

• Why This Chapter Is Important
• Preparing a Database to Be a Library
• Creating a Reference
• Debugging a Library Database
• Practical Examples: Building a Library for Your Application

Why This Chapter Is Important

As your knowledge of the VBA language expands and you become more proficient as a VBA programmer, you probably will develop functions and subroutines that you would like all your databases to share. Without the use of library databases, the code in each of your databases is an island unto itself. Although you can call the functions and subroutines within your code modules from anywhere in the same database, you cannot call these procedures from a different database.

Without a shared ...