Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 29. Leveraging Your Application: Creating Your Own Libraries

• Understanding Library Databases

• Preparing a Database To Be a Library

• Creating a Reference

• Debugging a Library Database

• Securing an Access Library

• Practical Examples: Building a Library for Your Application

Understanding Library Databases

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