Results 1 to 3 of 3
  1. #1
    jle0003 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    60

    Individual Security Level Permissions

    I have an Access 2007 database with 3 diiferent types of users:

    Administratrator: Has full control over all data and objects contained within the db.
    User: Has full access to add/edit data but is unable to make system wide changes.
    Guest: Has ability to view data only

    I have a Security table that contains the username and a permission level for each person with an account on the db.

    The question is, how do I apply the appropriate permissions to each user? As of right now, everyone can access all parts of the db.

    The Administrator is fine to leave as it is.
    Users need to be able to input and edit data using the forms in the db.
    Guests need view-only access to the forms.




    Please help!

    Thanks,

    Jamie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Use code to restrict user access to forms or reports or to enable/disable specific controls on form. Example:
    Code:
    Private Sub Form_Load()
    'restrict add/edit material and test to administrator
    If DLookup("Permissions", "Users", "UserNetworkID='" & Environ("UserName") & "'") <> "admin" Then
        Me.btnTest.Enabled = False
        Me.btnMaterial.Enabled = False
    End If
    End Sub
    Use filter criteria to restrict user access to records.
    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
    jle0003 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    60
    Thank you!

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

Similar Threads

  1. help with security level
    By nojtuag in forum Access
    Replies: 3
    Last Post: 10-19-2011, 01:27 PM
  2. User Level Security eliminated?
    By mjhopler in forum Security
    Replies: 6
    Last Post: 09-29-2011, 05:14 PM
  3. Alternative to user level security?
    By alsaf in forum Security
    Replies: 4
    Last Post: 08-20-2011, 03:19 AM
  4. No permissions after security was setup
    By postiekiddo in forum Security
    Replies: 3
    Last Post: 07-07-2011, 01:26 AM
  5. Field Level Permissions in MS Access 2003
    By ganeshvenkatram in forum Access
    Replies: 1
    Last Post: 06-21-2011, 07:00 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