Results 1 to 5 of 5
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Form Level Security

    Ref: https://www.accessforums.net/sample-...ent-20745.html



    What a wonderful tool! Thank you so much! Can you tell me if there is a way to assign user-levels to specific forms? For example, some employees need access to patient records but not HR information. Etc. Thanks!

    MOD EDIT: split thread
    Last edited by June7; 11-18-2013 at 02:15 PM.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Prevent user access to those forms. If there is a 'menu' with buttons to open said forms, then disable those buttons for those users.

    Be aware that accessibility to the navigation pane and ribbon and right click shortcuts makes this 'security' meaningless. Holding down shift key when opening a db will override most project settings and code execution.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by June7 View Post
    Prevent user access to those forms. If there is a 'menu' with buttons to open said forms, then disable those buttons for those users.

    Be aware that accessibility to the navigation pane and ribbon and right click shortcuts makes this 'security' meaningless. Holding down shift key when opening a db will override most project settings and code execution.
    Will do! Thanks much!

  4. #4
    katmomo5 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    47
    Is disabling buttons done in the 'menu" design? Or where is that found? I would like to disable buttons to specific forms and reports for certain users.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    It is accomplished with programming. This is a common topic. Search the forum and web. When you encounter specific issue, start a thread with your question.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Get User Automatically and Security Level example
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 12-10-2015, 12:11 PM
  2. Individual Security Level Permissions
    By jle0003 in forum Security
    Replies: 2
    Last Post: 08-13-2012, 01:38 PM
  3. Access user security level
    By tsv_tech in forum Access
    Replies: 2
    Last Post: 07-25-2012, 11:08 PM
  4. help with security level
    By nojtuag in forum Access
    Replies: 3
    Last Post: 10-19-2011, 01:27 PM
  5. User level security question
    By genesis in forum Security
    Replies: 1
    Last Post: 07-08-2009, 10:10 AM

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