Status Bar - Hide "View Shortcuts" Access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just upgraded to Access 2007 and I make heavy use of the Status Bar.
However, Access 2007 has made some modifications to the status bar where
there are some shortcuts in the lower right-hand corner of the screen. I
know I can hide them by right-clicking on the status bar and un-checking
"View Shortcuts", but that doesn't carry on to other users. Is there a way
that I can save this setting when the database is distributed to the users?
Those buttons will allow users to put forms in design mode and perform other
actions I wouldn't want them to do. I don't want to hide the status bar
completely. I'm looking for any way to do this either through VBA, or even a
group policy but I can't find anything. Thanks
 
The only way I've found to disable the Access 2007 status bar buttons while keeping the status bar in tact is to to the following:

1) Leave database in Access 2003 format
2) Implement user-level security in your database (see http://www.wikihow.com/Establish-User-Level-Security-in-Microsoft-Access)
3) Make sure you have at least two user groups - the ones you want to be able to see forms/reports in design view, and the ones you don't. I use something like 'dbUsers' and 'dbAdmins' user groups.
4) Remove 'View Design' privileges from the 'dbUsers' group.
5) Now, when users log on and they belong to the 'dbUsers' group, and they click the status bar buttons to change view, they will not have privileges to do so.

Note: You can deploy this database in an Access 2007 environment. As long as you leave the database in Access 2003 format, the user-level security functionality will be retained.

Chris
 
Back
Top