Solved

Unable to add trusted location in Access 2007

Posted on 2012-03-12
4
604 Views
Last Modified: 2012-03-12
I have a user right now, who, when he opens particular databases within Access 2007, recieves the message "Certain content in the database has been disabled", after which he can navigate to a cerain window and then enable the content.  I know that the method in which to avoid performing that step perpetually is to setup "trusted locatoins" on the network where access databases can reside.  However, when I attempt to go through the proper steps to add a trusted location within the local installation of Access, I receive the message "The remote or network path is not allowed by your current security settings".

Is this message a tell-tale sign that the network share in question was not configured to be trusted or is there something else on the desktop side that might have to be troubleshot?  I do not want to approach my network admins with this asking them to do extra work unless I have to, so I would like to verify the need to (or not to) get them involved.
0
Comment
Question by:AfpSysGrp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 37710171
Also, make sure that macro security is set to Low (it is High by default).  See the attached white paper.
White-Paper----Dealing-with-Macr.doc
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37710603
Is this the only user with this issue?

Does the user have rights to this location?
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 37710859
0
 

Author Comment

by:AfpSysGrp
ID: 37711059
It turned out that I needed to check the setting to <Allow trusted locations on my network> within <Trust Center Settings/Trusted Locations>.  This did the trick without the need to enable macros across the board.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question