Warnings About Templates and Add-Ins

When you open a database or database template, you might be prompted with a security alert. Databases can include potentially unsafe functions using the Microsoft Jet Expression Service and additional programming code called macros, which can contain viruses. You can protect your computer from viruses by running up-to-date antivirus software and setting your macro security level to high for maximum protection or medium for lesser protection. When you set the macro security level to high, some database functionality, such as wizards, is disabled. If macro security is set to medium, database users will be prompted to enable macros. Prompts also might appear to block potentially unsafe functions.

Set Macro Security

Click the Tools menu, point to Macro, and then click Security.

Click Security Level tab, and then click the Medium option.

Click the Trusted Publishers tab.

Select or clear the Trust All Installed Add-ins And Templates check box.

Click OK, and then if necessary, click Yes to block unsafe expressions and click OK to restart Access.

Enable Macros When You Open a Database

Open a database with macros.

If a macro security alert appears, click one of the following:

• Open to enable macros and open the database.

• Cancel to keep the current macro security level and stop the open database task.

• More Info to open Access online Help with more information about macro security.