Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 24. Creating Your Own Libraries

<feature><title>In This Chapter</title>

• Preparing a Database to Be a Library 972

• Creating a Reference 974

• Debugging a Library Database 982

• Securing an Access Library 983

</feature>

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 the functions and subroutines within your code modules can be called from anywhere in the same database, these procedures cannot be called from a different database.

Without a shared library of code and ...