Installing an Addin

An add-in only needs to be installed once in any Access database; after it is installed, it is available to all Access databases. To install the Extras 2007 add-in, first copy the library database to your AddIns folder. In Access 2007 running on Windows XP, the AddIns folder is in the same place as in Office 2003, C:\Documents and SettingsWser Name\Application Data\Microsoft\AddIns; if you are running Windows Vista, the Addins folder is in J:\Users\Helen Feddema\AppData\Roaming\ Microsoft\AddIns.

If you are attempting to install an add-in in Access 2007 running on Windows Vista, you may get a security warning. In that case, try running Access as an administrator, by right-clicking the MSACCESS.EXE file in the Office 12 subfolder under the Microsoft Office folder, and selecting the "Run as administrator" selection. Now, you should be able to install the add-in.

Another Vista requirement: In the USysReglnfo table, change the capitalization of "Menu Add-ins" (to "Menu Add-Ins", with a capital I). According to Microsoft, this case sensitivity will be addressed in an upcoming service patch, but you need to make the change to enable menu add-ins to work in Vista right now.

If you prefer to keep your own add-ins in a custom folder, you can add another folder to the list of trusted locations by selecting File, Access Options, and then selecting the Trust Center page of the Access Options dialog, as shown in Figure 14.16.

See the "Getting Your Add-ins to Work in Vista" sidebar in Chapter 15 for more information about the specific requirements for installing add-ins in Windows Vista.

FIGURE 14.16

The Trust Center page of the Access Options dialog box.

The Trust Center page of the Access Options dialog box.

Click the Trust Center Settings button and select the Trusted Locations page. Next, use the "Add new location" button to add the folder where you want to store your add-ins, as shown in Figure 14.17.

FIGURE 14.16

Next, open any Access database, and select the Database Tools tab of the Ribbon, click the Add-Ins drop-down in the Database Tools group, and select Add-In Manager (see Figure 14.18).

FIGURE 14.17

Adding a folder to the Trusted Locations group.

FIGURE 14.17

Adding a folder to the Trusted Locations group.

Opening the Add-In Manager in Access 2007.

Once you have opened the Add-In Manager, it looks just like the familiar dialog from earlier versions of Access, listing the add-ins that are found in the AddIns folder, and letting you install or uninstall them. To install the Extras 2007 add-in, select it and click the Install button, as shown in Figure 14.19.

FIGURE 14.19

Installing the Extras 2007 add-in.

TU Add-in Manager I

Available Add-ins: install

s-ii Ey',* if, Mllllll^^

| Add New... |


Helen Feddema

Database backup and listing of table and query fields (Access 2007


After clicking Install, an x appears to the left of the installed add-in, and when you close the Add-In Manager, several new selections appear on the Add-Ins menu, as shown in Figure 14.20.

FIGURE 14.20

Add-ins from the Extras 2007.accda library database on the Add-Ins menu.

ij^ Switch board Manager . JJ^l i En crypt with Password t—J*

Back up Database Back End

Rename Form Controls Rename Report Controls Rename Database Objects

. The three menu add-ins starting with "Rename" at the bottom of the list are from my t*; 2F -v u Lv J LNC Rename add-in.

0 0

Post a comment