FIGURE 13.8
A COM add-in button on the Add-Ins tab of the Ribbon in Access 2007.If you don’t see your COM add-in’s button(s) in an Access database after copying the DLL file
to the Add-ins folder, you can install the add-in from the COM Add-Ins dialog, which can be
opened from the Add-ins page of the Access Options dialog. To install a COM add-in manually,
do the following:- For Windows Vista only, run Access as an administrator by right-clicking the
MSACCESS.EXE file in the Office 12 subfolder under the Microsoft Office folder,
and selecting “Run as administrator” from its right-click context menu. - In an Access database, click the Office button, then click the Access Options button at the
lower right, as shown in Figure 13.9.
FIGURE 13.9
Opening the Access Options dialog.- Select the Add-ins page on the Access Options dialog to see your installed add-ins (you’ll
see both Access and COM add-ins listed there, plus one or more add-ins that are installed
with Office). If your add-in is listed in the “Inactive Application Add-Ins” group, you will
need to install it in the COM Add-ins dialog.
Part III Adding More Functionality to Office