Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    New York
    Posts
    47

    Unanswered: Toolbars controlled by Security Groups

    I have a database with security set up by groups. I would like to create specific toolbars for accessing forms based on Security Groups. This I can do but I have no idea how to show only the toolbar for the person who is logged in. Help would be greatly appreciated.
    Terri Gavin

  2. #2
    Join Date
    May 2010
    Posts
    601
    I assume you are referring to the built in User Level Security. Since it is no longer supported in Access 2007's new format, I have not used it for a while now. I have developed my own.

    I would suggest reading this:

    How I use Microsoft Access User-Level Security by Jack MacDonald
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Oct 2009
    Posts
    340
    another consideration is separate FEs. That is pretty common for me. I have an 'Admin' FE that keeps leaves in all tools but a User FE where it is stripped down.

    now getting into multi FEs becomes a hassle if development isn't complete - as you will end up with 2x or 3x the work for each change.

    I don't know if there is a way to 'call' in a custom tool bar based upon a value. So let's say you have a log in screen that establishes a value for the user....then when other forms are opening during the OpenEvent (or Load) it looks at that value of the login screen and then dynamically calls in a custom tool bar. That may be possible. It would be sexy.

  4. #4
    Join Date
    May 2010
    Posts
    601
    It is definitely possible to do.

    Here is some air-code to give you an idea:

    Code:
    Select Case  CurrentUser()
    
        case "HiTechCoach"
    
             DoCmd.ShowToolbar "Menu Bar", acToolbarYes
             DoCmd.ShowToolbar "AdminTools", acToolbarWhereApprop
    
        Else Case
    
    
             DoCmd.ShowToolbar "Menu Bar Admin", acToolbarNo
             DoCmd.ShowToolbar "Menu Bar Users", acToolbarYes
    
             DoCmd.ShowToolbar "AdminTools", acToolbarNo
    
    
    End Select
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •