Results 1 to 4 of 4
  1. #1
    Nixx1401 is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Location
    Barbados
    Posts
    115

    Allowing 1 user to edit and the other to read only


    Hi there,

    I am using access 2010. I split the database and would like one user to be able to edit and other users to read only. Please explain the step involved

  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
    Need to identify the users. Either hard code the user privileges or create a users table with defined privileges. Identify the user when the db is opened either by login procedure or pull username from the network login. Open forms in mode appropriate to the identified user.

    However, be aware that holding down the shift key will override many optional database settings and bypass code execution on open which means the db is wide open to anyone. F11 will also expand/collapse the navigation pane. Unless you want to publish the db as an executable.

    Login and user privileges are common topics. Search forum or web.
    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
    Nixx1401 is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    Feb 2010
    Location
    Barbados
    Posts
    115
    Thank you very much for your response. I was able to create the user and security table for the User Level Security on the dbase but I have a search text box will filters the customers names and takes to the required record it is not filtering. the open event i have allowedits, allowdeletions and allowadditions set to false. Any ideas?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Would have to review code. Suggest not trying to set those properties directly with code. Leave them all set to Yes. Then use OpenForm arguments:

    Docmd.OpenForm "form name", , "filter criteria here" , , acFormReadOnly
    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. 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
  2. Replies: 5
    Last Post: 03-21-2013, 01:59 PM
  3. Help with allowing administrator access using user name
    By BiotechJen in forum Programming
    Replies: 4
    Last Post: 01-30-2013, 11:02 AM
  4. Split Database only allowing single user access
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 11-08-2011, 11:12 PM
  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