Excel 2013 Word 2013 PowerPoint 2013 Excel 2010 Word 2010 PowerPoint 2010 Project 2010 Project Standard 2010 Excel 2007 Excel Starter 2010 More...Less
The Message Bar displays security alerts when there is potentially unsafe active content (such as macros, ActiveX controls, data connections and so on) in the file that you want to open. Or, you may have a read-only file that you ready to edit and need to enable editing. In such cases, the Message Bar appears, yellow or red, with a shield icon, to alert you about potential problems. If you know the content is from a reliable source, on the yellow Message Bar, you can click Enable Content to enable content to make it a trusted document or enable content for a session. On the red Message Bar, you can click the warning text. In the Office Backstage view, the view that you see when you click the File tab, you can click Edit Anyway.
The following images are examples of Message Bars.
If you don't want security alerts, you can disable the Message Bar. Conversely, you can enable the Message Bar to increase security.
-
In an Office program, click the File tab.
-
Click Options.
-
Click Trust Center, and then click Trust Center Settings.
-
Click Message Bar. The Message Bar Settings for all Office Applications dialog box appears.
-
Show the Message Bar in all applications when document content is blocked This is the default. The Message Bar appears when potentially unsafe content has been disabled.
Note: The option is not selected, and the Message Bar does not appear, if you select Disable all macros without notification in the Macro Settings area of the Trust Center.
-
Never show information about blocked content This option disables the Message Bar and no alerts appear about security issues, regardless of any security settings in the Trust Center.
-
Note: Changing the Message Bar options in the Trust Center does not change the Protected View Message Bar.
The following image is an example of the Message Bar area of the Trust Center.
Important: We advise that you do not change security settings in the Trust Center. Consequences can be loss of data, data theft, or security compromises on your computer or network.
Top of Page
Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More...Less
This article contains an overview of how trust works in Access and what factors you should consider when you decide whether to trust an Access desktop database.
By default, Access disables all the potentially unsafe code or other components in a database, regardless of the version of Access that you used to create the database.
When Access disables content, it informs you of the action by displaying the Message Bar.
If you see the Message Bar, you can choose whether to trust the disabled content in the database. If you decide to trust the disabled content, you can do so in two ways:
-
Use the Message Bar Click Enable Content on the Message Bar. When you choose this option, you may need to repeat the procedure if the database changes.
-
Trust the database permanently Place the database in a trusted location — a folder on a drive or network that you mark as trusted. When you choose this option, you no longer see the Message Bar, and you never have to enable the database content as long as the database remains in the trusted location.
If you do not want to trust the database, ignore or close the Message Bar. When you ignore or close the Message Bar, you can still view the data in the database and use any components in the database that Access has not disabled.
Top of Page
Before you decide whether to trust a database, you should consider the following factors.
-
Your own security policy You or your company may have a security policy in place that specifies how to handle Access database files. For example, you might have a very robust backup system in place, and decide that you are willing to trust most database files, unless you have a specific reason not to. Conversely, you may not have a good backup system, and therefore might want to be very cautious when you decide whether to trust a database.
-
Your goal When Access disables content in a database that you have not trusted, it does not block your access to the data in that database. If you want to review the data in a database and do not want to perform any actions that might be unsafe, such as running an action query or using certain macro actions, you do not have to trust the database. If you are not sure whether an action is considered unsafe, you can try to perform the action while the database content has been blocked by disabled mode. If the action is potentially unsafe, it will be blocked in this circumstance.
-
The database source If you created the database, or if you know that it came from a source that you trust, you can decide to trust the database. If the database came from a possibly unreliable source, you might want to leave the database untrusted until you make sure that its content is safe.
-
The contents of the database file If you cannot make a trust decision based on other information, you might consider thoroughly examining the database contents to see what potentially unsafe content the database might contain. After you conduct a complete check and are sure that the content is safe, you can decide to trust the database.
-
The security of the location where the database is stored Even if you know that the contents of a database file are safe, if the file is stored in a location that is not fully secure, someone might introduce unsafe content into the database. You should be careful when deciding to trust database files that are stored in locations that might not be secure.
Top of Page
After you decide to trust a database, you can either trust it by using the Message Bar, or by putting the database file in a trusted location.
The Message Bar appears just under the ribbon.
-
In the Message Bar, click Enable Content.
If you don't see the Message Bar but content has been disabled, make sure that the Message Bar is enabled.
-
Click File > Options.
-
In the left pane of the Access Options dialog box, click Trust Center.
-
In the right pane, under Microsoft Office Access Trust Center, click Trust Center Settings.
-
In the left pane of the Trust Center dialog box, click Message Bar.
-
In the right pane, click Show the Message Bar in all applications when active content, such as macros and ActiveX controls, has been blocked, and then click OK.
-
Close and reopen the database to apply the changed setting.
Once the Message Bar is visible and enabled, you can use it to enable content.
To specify that a given database is trustworthy and should be enabled by default, make sure that the database file is located in a trusted location. A trusted location is a folder or file path on your computer or a location on your intranet from which it is considered safe to run code. Default trusted locations include the Templates, AddIns, and Startup folders. You can also specify your own trusted locations.
Tip: If you want to know the path of the current database, click the File tab to open Backstage view. The full path of the current database's location is listed on the Info tab.
-
Open the folder where the database file is currently located, and then copy the database file into the trusted location that you want.
-
On the File tab, click Options.
-
In the Access Options dialog box, on the left, click Trust Center.
-
On the right, under Microsoft Office Access Trust Center, click Trust Center Settings.
-
In the left pane of the Trust Center dialog box, click Trusted Locations.
-
To add a network location, in the right pane, select the Allow Trusted Locations on my network check box.
-
Click Add new location.
-
In the Microsoft Office Trusted Location dialog box, use one of the following methods:
-
In the Path box, type the full path of the location that you want to add.
-
Click Browse to browse to the location.
-
-
To specify that subfolders of the new trusted locations should also be trusted, select the Subfolders of this location are also trusted check box.
-
Optionally, in the Description box, type a description for the trusted location.
Top of Page
Enable or disable macros in Office files
Enable or disable ActiveX settings in Office files