O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

USING ACCESS CODE LIBRARIES

Access, by using references and VBA, enables developers to create their own libraries of VBA modules. As with add-ins, each library can then be used in multiple or distributed applications. There are a number of pros and cons to using code libraries.

Looking at the Pros and Cons of Code Libraries

Here are some of the pros of using code libraries:

  • Code libraries enable you to create routines once and then use them in multiple applications. This reduces redundant code.

  • When changes are made to the code for fixes or additions, they have to be made in only one place.

  • If you want to distribute your library to clients without letting them have the source, you can make an MDE from the library, but still give them the source ...

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