Trust Center Macro Settings greyed out

[M Skabialka]

One of the departments I have created databases for is upgrading to Office
2007 before the end of the year. I tested one of my databases on a machine
in that department that already has Access 2007 but when the database opened
none of the VBA code was available. There was a message in the Message Bar
saying something about security and it gave an option of enabling content,
which allowed the code to run. But this only works for this instance of
opening Access. Every time you open a database it asks the same thing.
I tried going into the trust center to change the macro settings to enable
all macros, pretty much an absolute necessity in a database with multiple
forms and reports called by VBA code, but all of the settings are greyed
out. Obviously someone has decided that for all Office 2007 installations
there will be tight security, but the users rely on these databases for
critical info.
What setting do I need to ask the powers that be to loosen up so users can
use these databases without the nagging security prompt?
Mich

 

[Arvin Meyer [MVP]]

You need to build a Trusted Location, which is a folder on the user's
workstation which contains the front-end of a shared database.

 

[John Spencer]

Did you go to the TRUST center and set a directory as Trusted. Then you put
all your databases into the Trusted folder to allow them to run code.

Click on the following in order
Button
Access Options (bottom of screen)
Trust Center
Trust Center Settings
Trusted Locations
Add New Location
Hopefully, you can take it from here.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[M Skabialka]

Today I am in another location so can't try this, but will I have to do this
for the front and back end, or just the front end on their computer? (Most
of them keep the front end on their desktop, but the back end is on the
server.)
Thanks for great advice as always,
Mich

 

[John Spencer]

I believe you only need to do this for the front end. Most backends don't
have any code to execute.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[M Skabialka]

Unfortunately the option of putting all databases into the Trusted folder is
also grayed out.
Do you have any other ideas on how to fix this?
Mich

 

[John Spencer]

Do you mean that in Windows Explorer you can't move the database application
into the folder you have made the trusted folder?

If that is the case, then you will have to get the necessary privileges to do so.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[M Skabialka]

When you go into Access Options to the Trusted locations area, all options
are grayed out - I can't add a new location, remove, modify, change check
boxes, etc. So somebody has locked these changes out. But now I have to
convince these people that this setting should be changeable, or to provide
some way to allow code to run in these databases without having to change
the security settings every time they open a database. What exactly should
I be requesting - technically speaking for these IT gurus?

Another strange feature considering this high level of security is the
Navigation bar. I changed the option to NOT Display Navigation Pane but it
is still there compressed over to the left side, easy to open by curious
users. I would rather it be totally invisible - is there another setting I
also have to change?

Mich

 

[John Spencer]

Sorry but you are beyond by expertise at this point. I suggest you start a
new thread since this one is buried so deep.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[M Skabialka]

I think I have to give up on the security issue - there are Group Policies
that are not going to be changed.
I'll continue the Navigation Pane pain in another thread.
Thanks,
Mich