• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 29. Leveraging Your Application:... > Understanding Library Databases

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

Without a shared library of code and other standard objects, you will find yourself copying routines and other database objects from one database to the next. The library database can be used by all your applications and distributed to all your users. A library database is just like any other database; it is simply a collection of procedures and objects that you want to share among numerous databases. The only difference between the library database and other databases is in the way the database is referenced. Instead of opening a library database to use it, you reference it from another database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint