14.3. Linking Libraries in Access 2007

There are two ways to link a library to an Access 2007 database: by referencing the library or by declaring it.

14.3.1. Referencing a Library

When you set a reference to an external library in Access 2007, you can use its functions as though they were built-in to Access. You can reference type libraries, object libraries, and control libraries.

For example, because the Microsoft Excel Object Library is itself a library of functions, you can reference (link to) it in Access and use its functions as though they were part of Access. To reference a library, select Tools References in the Visual Basic Editor. The References dialog box opens, as shown in Figure 14-3.

Figure 14.3. Figure 14-3

Browse the list to see a large range of libraries. Some typical libraries are:

  • Microsoft Office 12.0 Object Library

  • Microsoft Excel, Word, and the other members of the Office suite

  • Microsoft ActiveX Data Objects 2.8 Library

  • Microsoft Office 2007 Access database engine Object Library

  • Microsoft Scripting Runtime

  • Microsoft SQLDMO Object Library

Of course, many of the libraries you'll find listed in the References dialog box are from suppliers other than Microsoft, and depend on the applications you have installed on your computer. You might find such things as:

Get Access™ 2007 VBA Programmer's Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.