Access 2003 VBA Programmer's Reference

B.1. Types of References

You can add references to many types of libraries from your Access projects. Library types include the following: type or object libraries (OLB, TLB, and DLL), ActiveX controls (OCX) and references to other Access databases (MDB and MDE), Access add-ins (MDA), and Access projects (ADP and ADE).

An object library or type library generally provides functionality for access to other applications or adds functionality to use in your Visual Basic code. For example, Microsoft Office exposes its Component Object Model (COM) through the Microsoft Office DLLs. These include the Microsoft Access 11.0 Object Library, Microsoft Excel 11.0 Object Library, Microsoft Word 11.0 Object Library, to name just a few.

ActiveX Controls generally include controls that you can add to your user interface. These controls can display data on forms or provide an access method to data through a form with little or no extra programming. For example, DBi Grid Tools control displays a grid of data, a two-dimensional table that looks similar to Access's datasheet view. The tool has properties to indicate which data to display, adjust colors of cells, and add icons and much more, all without programming. The Grid Tool also enables more functionality through Visual Basic when a reference is made to the Grid Tool DLL.

Access add-ins provide enhanced functionality to Access as a whole. For example, the "New Form" wizard provided with Access is an add-in. By now you know the form wizard leads ...