Results 1 to 2 of 2
  1. #1
    ludovic_44 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2014
    Location
    mauritius
    Posts
    15

    Permissions level in access

    HI all



    I'm quite new in access, i have created a dashboard which have plenty of forms
    But i would like to create a module to put the codes for the below criteria

    Read only ability to read only
    administrator ability to read, edit not delete
    supervisor ability to read, edit, delete
    Developer ability to read, edit delete and add
    Data Processor ability to read and add data only

    each users will be given one of the above permission, what im looking for is, when a form is loaded by the users, it assigns automatically the permission
    I dont know how to write these code so that it gets the forms name and it calls the specific module and assign the permission

    Note that there are lots of forms (abour 150 forms)

    Can you please help me from this trouble

    Thanking you

    Ludovic

  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,902
    Code can manage availability of controls such as command buttons dependent on user identity.

    Various methods to capture user identity and match to record in UserInfo table to determine permission level.

    This is a common topic in forum.
    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. Linking Tables at the Table Level Vs. the Query Level
    By Tammy in forum Database Design
    Replies: 3
    Last Post: 12-03-2014, 01:34 PM
  2. User permissions - access 2010
    By Outlook in forum Security
    Replies: 3
    Last Post: 12-03-2012, 08:19 AM
  3. Individual Security Level Permissions
    By jle0003 in forum Security
    Replies: 2
    Last Post: 08-13-2012, 01:38 PM
  4. Field Level Permissions in MS Access 2003
    By ganeshvenkatram in forum Access
    Replies: 1
    Last Post: 06-21-2011, 07:00 AM
  5. Access permissions
    By paulbrog in forum Access
    Replies: 1
    Last Post: 05-05-2009, 11:14 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