User group security for menus/toolbars

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

How do I limit access to menus and toolbars in a database
that has user-level security set up.

For example, I don't want certain users to be able to do
anything but navigate through forms and preview/print
reports. I don't want them to be able to see any of the
other menus. Is there a way to selectively do this by
user or by usergroup?
 
Automatically, no. With VBA Code, yes.

When the form opens, determine which group the user belongs. Have a table
that defines which toolbars each group should get. Refer to this table, and
set appropriately in the Form_Open event.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top