[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Access 2007 Migration and the New Security features

Published on
10,406 Points
1 Endorsement
Last Modified:
I just got finished migrating over forty five Access 97, 2000 and/or 2003 databases and the first "issue" I was presented with was the new security used in Access 2007.  

I also discoved the easiest way to walk a user through setting up the security is with a document.  Now granted, I had to walk more than a few via phone but this document should help most of us when it comes to migration and even database application moving.

The first time you open your migrated database you may have an “Security Warning” and even an Error message.  This is due to the new security that is provided by Access 2007.  The following steps will solve the issue.
1)  Open your Application via the shortcut or once inside Microsoft Access 2007 (MS Circle | Open)
2)  Answer OK to the error window (if there is one.)
3)  If there is no Security Warning bar on top of the main window, you are done.  If there is OR if you open an different Database and get the security bar, complete the following:
4)  Click the "Options..." button on the Security Warning bar.
5) This opens the Security Alert Window.  
 Security Alert6)  Click on Open the Trust Center link on the bottom of the Form.
 Trust Center7)  Click on Trusted Locations (Left window, second from the top)
 Trusted Locations8)  If the Applications is on a Network Drive, Be sure to click the "Allow Trusted locations on my network"
9)  Click on Add New Location
 Add Location10)  Enter the path of your Database or Access Applications
11)  If there are sub folders required, check the "Subfolders of this location are also trusted"
12)  Click OK
13)  Click OK
14)  Click "Enable this Content"
15)  Click OK

I created a Region Secific document for the people that I needed to assist in that first run of the migrated databases.  Using site specific screen shots really helped them to understand what they needed to do.

Featured Post

Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month