How do I limit access to menus/toolbars

[Todd]

I'm the database admin for a multi-user database.

I've got user-level security setup to limit which tables,
forms, etc are accessible.

However, I can't find anything to limit access to menus
and toolbars.

I'd like to force the users to only navigate with command
buttons through the forms that I've created and hide all
the menus and toolbars except a few basic functions like
print, exit, etc...

Is there anyway to do this?

 

[Arvin Meyer]

I'm the database admin for a multi-user database.

I've got user-level security setup to limit which tables,
forms, etc are accessible.

However, I can't find anything to limit access to menus
and toolbars.

I'd like to force the users to only navigate with command
buttons through the forms that I've created and hide all
the menus and toolbars except a few basic functions like
print, exit, etc...

Is there anyway to do this?

You can create your own menus and hide the standard ones. Make sure that the
startup options have menu and toolbar changes enabled, then right-click on a
toolbar, choose customize, choose New ... and experiment a little until you
get what you want. Then turn off the built-in toolbars and specify in the
form and report property sheets which toolbars to load.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Todd]

Thanks. This is really helpful. Couple of questions
though.

Is there a way to set menus/toolbars by User or User Group?

It seems like even if you do turn-off the menus and
utilize a custom one, anyone can still go in and un-hide
the normal toolbars? Is there a way to get around this,
ie lock them for certain users?

How do you turn off the menu for the print preview view?

 

[Arvin Meyer]

I'm not sure I understand. Look. once again, at the Startup dialog form. How
did you get there? Tools menu, right? Now if that menubar isn't there, and
there's no tools menu on your custom menu, how can they get there? <They can
but it sure isn't easy> If you implement security you can lock them out of
permission to change anything in the program, and you can also lock it
certain users:

http://support.microsoft.com/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access