Results 1 to 3 of 3
  1. #1
    Timothy4 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    Restrict user access using Access Runtime and different levels of security to records

    I am looking for a little advice, Here is my situation; Ihave different styles of users. (1 )Office personnel that need to see allrecords. (2) I have attorneys that should only see clients that are assigned tothem and no others. (3) I have sales people that should only see records thathave not been assigned to an attorney.
    I am at the very earliest stages of constructing theDatabase and I am looking for advice on how to construct the DB to accomplishthe correct people getting access to the correct records. Whether it be usinglinked tables, VBA or some other method that someone else has been successfulwith. I should mention I am using Access 2010 and when uploaded it will berunning on a remote server using Access runtime to keep people out of the tables.Any advice would be appreciated. Also if you are so inclined I am available tocall or be called so we can discuss if this works better for you.


  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
    This involves developing a login procedure. The core of which is a Users table with username and permissions level. Username can be applied as filter criteria in queries and/or permissions level can manage availability of controls (buttons, data entry) and which objects (forms/reports) would be opened.

    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.

  3. #3
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    This link may be helpful in understanding and setting up permissions

    http://www.mrexcel.com/forum/microso...ns-system.html

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

Similar Threads

  1. Replies: 1
    Last Post: 03-27-2014, 07:34 AM
  2. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  3. Replies: 2
    Last Post: 01-26-2013, 11:38 PM
  4. Access User Security
    By KkcBroad50s in forum Security
    Replies: 3
    Last Post: 04-29-2011, 09:31 AM
  5. Problem with Access 2007 Runtime, Vista and security
    By JackBeNimble in forum Programming
    Replies: 0
    Last Post: 02-05-2011, 07:46 PM

Tags for this Thread

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