Geeks With Blogs


Add to Google

Tim Hibbard CEO for EnGraph software

As an update to this post, this is how you enable Access 2007 to work with your Access applications that require extended security.

1) Open "Customize Quick Access Toolbar" menu to the right of the office button
2) Select "More Commands"
3) Click "Trust Center" menu button on sidebar
4) Click "Trust Center Settings" button on main pane
5) Click "Macro Settings" menu button on sidebar
6) Select "Enable all macros"
7) Click "OK" to close Trust Center
8) Click "OK" to close Access Options


Posted on Monday, November 27, 2006 11:58 AM MS Office | Back to top

Comments on this post: Access 2007 Security Settings

# How to enable security settings for ParaPlan
Requesting Gravatar...
With newer version of Access, Microsoft has modified how the security system works.  To make...
Left by EnGraph Software on Dec 15, 2006 10:32 AM

# re: Access 2007 Security Settings
Requesting Gravatar...
Would be good if someone knows how to do it in ms access runtime
Left by Andrew on Aug 09, 2007 7:27 PM

# re: Access 2007 Security Settings
Requesting Gravatar...
heres my issue, built a facilty db in Acess 2003 in XP using user level security for 9 users, tried to migrate to 2007 but became a disaster as 2007 doesnt use user level security, Trying to convert to 2007 and now it says that I (the owner) no longer have any rights to the objects. I tried to creat a new 2007 db (Vista) and import the objects, works for tables, queries but not for forms, macros etc, I changed the trusted macros to enable and the folder to full rights but still makes me sign in as admin and wont allow me to become owner(need to see my administrator to get rights, now when I open any db new or other it makes me sign in as admin and I cannot get the owner back, can you help?
Left by Troy on Jul 06, 2009 7:48 PM

# re: Access 2007 Security Settings
Requesting Gravatar...
I would like to change the Macro Settings from "Enable all macros....." to "Disable all macros..." on a hundred PC's, is there any I can do this with out touching each machine or at least I would like to run a script on each machine that will do this.
Left by Kev on Nov 09, 2010 2:38 PM

Your comment:
 (will show your gravatar)

Copyright © Tim Hibbard | Powered by: