Microsoft introduced a new feature in Access 2007 which tells access to only run certain commands if the database is “trusted”.

Many people first meet this when they have converted a database froma previous version, then are surprised when the converted database does not run as expected.

Here is a quick guide on how to get your database trusted by Access.

1. Open the database holding the shift key down
2. Click on the “Office button” (top left hand corner) and select “Access Options” (bottom right of menu)
Office button -> Access Options
3. Select “Trust Center” from the left hand menu



Access Options Menu

4. Click “Trust Center Settings” (Right middle of window)


Select "Trust Center Settings"

5. Select “Trusted Locations” from the “Trust Center” menu


Trust center menu

6. Select “Add new location” (Bottom of window)


Ad new trusted location

7. And add the location (folder, directory) of the database that you are trying to open.
8. Close and re-open the database.