Database Reference
In-Depth Information
Enabling macros and other active content
Some databases contain macros and other active content that can run code on your
computer. In most cases, the code is there to perform a database-related task, but
hackers can also use macros to spread a virus to your computer. When you open
a database that is not stored in a trusted location or signed by a trusted publisher,
Access displays a security warning below the ribbon.
While the security warning is displayed, the active content in the database is disabled.
You can enable macros and other active content in three ways:
▪
By enabling the macros for use in the current database session.
▪
By adding the database publisher to the list of trusted publishers. This option
is available only if the publisher's digital signature is attached to the database.
Access will then automatically enable macro content in any database that is
also signed by that publisher.
▪
By making the location of the database a trusted location, or moving the data-
base to a trusted location. Access automatically enables macro content in any
database saved in that location.
To enable macros for the current database session only:
▪
In the security warning bar, click
Enable Content
.
To add the publisher of a digitally signed database to the Trusted Publishers list:
In the security warning bar, click
Some active content has been disabled
.
1
On the
Info
page of the
Backstage
view, click the
Enable Content
button, and
then click
Advanced Options
.
2
