Results 1 to 4 of 4
  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659

    Question Set one user to be Read Only

    I have 1 Datafile used as a backend and 8+ front ends. The Fronts ends all are copied to Each users PC depending on which user needs what.



    Can I changed the file security settings on the datafile to only allow a specific domain user read only access? I have tried setting the Datafile itself and also the Parent Node with inheritances of objects in the containing folders. This didnt work, the use can still enter and do the same thing all the other users do.

    I would like to keep this all leveraged by the Domain and not access if possible.

    Any Ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I have a tUser table,and their Rights (a code)
    When a form loads it looks at the user ID and set it to ReadOnly if they don't have the correct rights code.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I have a tUser table,and their Rights (a code)
    When a form loads it looks at the user ID and set it to ReadOnly if they don't have the correct rights code.


    vUserID = Environ("Username")
    vUserCode = DLookup("[Code]","tUsers","[UserID]='" & vUserID & "'")

    if vUserCode = "0" then
    me.txtName.locked = true
    me.subForm.locked = true
    'etc
    endif

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I am looking for a non code based update. Like leveraging the NTFS security.

    I do have a function that i use to handle calls like you have suggested.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-02-2014, 11:43 AM
  2. Replies: 3
    Last Post: 02-28-2014, 10:17 AM
  3. A multi-user form for Read-Only information
    By PA at UPenn in forum Forms
    Replies: 3
    Last Post: 01-06-2014, 03:38 PM
  4. Replies: 10
    Last Post: 01-07-2013, 07:29 AM
  5. Problem with Read Only User
    By admaldo in forum Security
    Replies: 0
    Last Post: 04-24-2006, 11:51 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