Results 1 to 4 of 4
  1. #1
    Brightspark98 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    57

    Multi Level User Accounts

    Hi does anyone have any good resources or tutorials on how to set up multi level user accounts?

    I would like

    Admin - Full Access

    User - Restricted access to certain areas depending on identity.

    i.e
    user 1 can access forms 1,2,3


    user 2 can access forms 1,2,3,4,5
    user 3 can access forms 3,4,5 etc.

    Many thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I have a tUsers table, with userID, Name, and Level
    when user opens the db, the main menu form will open and read the userID. Then lookup that persons rights in order to enable/disable controls.
    Code:
    sub form_load()
    dim vUserID, vLevel
    
       vUserID =  Environ("Username")      'get userID
    
                        'get level from user table
       vLevel = Dlookup("[Level]","tUsers","[userID]='" & vUserID & "'")
    
    'now, enable/disable items on form
       select case vLevel
             case "A"  'admin 
                 'all is enabled
    
             case "U"  'normal user
                 txtBox1.enabled = false
                 txtManager.enabled = false
    
             case "M"  'manager
                 txtBox1.enabled = false
       end select
    end sub

  3. #3
    Brightspark98 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    57
    How do you allocate rights to each user group?

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    That's the managers job. Managers can enter userID, and level.
    (they can't set Admin)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  2. Access 2007 Admin and User accounts
    By jle0003 in forum Security
    Replies: 1
    Last Post: 07-30-2012, 03:22 PM
  3. Replies: 1
    Last Post: 08-13-2011, 04:44 AM
  4. Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  5. profile each user accounts?
    By jun90 in forum Access
    Replies: 1
    Last Post: 01-18-2010, 03:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums