Access.2007.VBA.Bibl..

(John Hannent) #1
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 USysRegInfo 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 informa-
tion about the specific requirements for installing add-ins in Windows Vista.

FIGURE 14.16
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.

CROSS-REFCROSS-REF


Part III Adding More Functionality to Office

Free download pdf