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
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.
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.
You can add code to disable shift by-pass key. You also can disable the navigation pane. Then disable most of the File/optionsPrevent 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.