Results 1 to 3 of 3

Access level?

  1. #1
    lithium is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    72

    Access level?

    Okay, I am building a database application in Access 2010 and one of the requirements is to find a way to have half the users be able to perform add/edit/delete functions to the database and the other half only read the information. Is this achievable? I did read that new access eliminated the user level security but isnt there a work around?



    Keep in mind, I do work for a large company and this essentially was going to be placed in a shared folder and the users can open and do their work from it.

    Actually, there is multiple parts to the db. One of the tables out of the three is the one that the other dept should be able to make changes and add too freely, but the other two tables need to only be my dept. I found a way to set user permissions to the actual db file which would work but would in effect not allow them to update that table inside this db...

  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
    48,401
    The workaround is a UserInfo table, identifying the user, and have code open forms according to user permissions.
    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
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    Note that you write: going to be placed in a shared folder and the users can open and do their work from it.

    That sounds like an incorrect installation; a multi user Access application must be split; you put the common back end file on the shared server but each user must have their own front end file....

    The only alternative to J7's advice is to have separate front ends; 1 that is read only and the other that is fully capable

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

Similar Threads

  1. Access user security level
    By tsv_tech in forum Access
    Replies: 2
    Last Post: 07-25-2012, 11:08 PM
  2. Clarifications on User-level access
    By Datech in forum Security
    Replies: 5
    Last Post: 04-30-2012, 10:32 AM
  3. User-level access to specific records
    By gbonnaville in forum Security
    Replies: 7
    Last Post: 03-29-2012, 11:14 AM
  4. Access Level Controlled Forms
    By injanib in forum Forms
    Replies: 4
    Last Post: 06-15-2011, 01:54 PM
  5. Field Level Access
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-09-2009, 11:59 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
  •  
Tech Forums: Microsoft Office Forums