Results 1 to 3 of 3
  1. #1
    brispark is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    1

    Form Level Security

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

    This is great but how do i set permissions for individual forms and reports?

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

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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
    gandhawk is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    2
    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.
    You can add code to disable shift by-pass key. You also can disable the navigation pane. Then disable most of the File/options

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

Similar Threads

  1. Form Level Security
    By Gina Maylone in forum Security
    Replies: 4
    Last Post: 12-18-2013, 01:21 PM
  2. help with security level
    By nojtuag in forum Access
    Replies: 3
    Last Post: 10-19-2011, 01:27 PM
  3. User Level Security eliminated?
    By mjhopler in forum Security
    Replies: 6
    Last Post: 09-29-2011, 05:14 PM
  4. Alternative to user level security?
    By alsaf in forum Security
    Replies: 4
    Last Post: 08-20-2011, 03:19 AM
  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