Office 2007 - Access

Lesson 4: Security

4/72 Lessons 

Muting non reliable databases

When you open a database without a digital signature, or that was not stored in a trusted location, you get to see a security warning, under the “Ribbon”.
This states that certain content (eg “Macros”) from this database are disabled.
You can temporarily enable it by clicking the les04_image002_en
“Options” button in the dialog that appears, check the “Enable this content” box.
This warning bar will disappear and the ‘potentially dangerous’ content will be enabled. If you wish to just make the bar disappear, click the X on the right side of the bar.
The next time you open this file, the security warning will be shown again.
If you do not wish to see this warning, place this file in a trusted folder, a reliable place in the “Trust Center” or give your database a digital signature.

The “Trust Center”

When you open a file that contains “Macros” or VBA code, a message bar is displayed to warn you that certain content from the database is disabled.
The message bar will supersede the various dialog boxes in previous versions of “Access”.

The area of security has been improved with the new option in “Access” 2007 : “Trust Center”.
To get the “Trust Center” window, click the “Office” button and click “Access Options”.
In the “Access Options” tab, select “Trust Center”.

The upper section contains links to the “Microsoft privacy statements”.
The middle section contains a link to the Windows Security Center, and a link to “Microsoft Trustworthy Computing”.
The lower part, which interests us, contains a button that opens the settings for the “Trust Center”.
Click “Trust Center Settings” button.
This opens the “Trust Center” dialog.
In this dialog we have six categories with different settings.
The first category is “Trusted Publishers”, where we see a list of all database publishers who have placed a digital signature in the application. You can view or remove publishers from this window.

The second category is “Trusted Locations” which are folders and subfolders that we have set as “reliable”. Each database stored in these folders or subfolders is considered safe. That also applies to all contents of this database.
You can add or remove folders from this window.

In the third category “Add-ins”, we can set certain criteria for add-ins. An Add-in is a custom command or a specialized function to be added to the system program.

In the fourth category “Macro Settings”, we can choose several options for “Macros”. These all seem clear to me.

In the fifth category “Message Bar”, we can select to display the message bar on or off.

And in the last category “Privacy Options” allows us to choose several options for making “Office” online or off.

Click the OK button when you have entered the various options.
Click the OK button again, to close the “Access Options” dialog

You've completed Lesson 4