Results 1 to 5 of 5
  1. #1
    injanib is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2011
    Posts
    67

    Access Level Controlled Forms

    Hi all,

    I am using Access 2007. There are certain areas on all of my forms that I want to limit access to for some users. For example, depending on which user is using the forms, I need some controls or buttons to be disabled.

    I will probably end up splitting the database, and I will have 3-4 users simultaneously. But I am yet to know how to make the database able to be used by multiple users with different access level.



    Any suggestions will be appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Have a login form to get user ID or get it from their network login. Have code behind the various forms that disable or enable (or lock or set visibility) controls according to user ID.
    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
    injanib is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2011
    Posts
    67
    Thanks,

    I think the easiest way for me, if possible, is to have the open event of the form check if the user is a standard user or administrator. The work stations are Win 7 with one Admin account and one Standard User account.
    Is it possible to check whether the user logged in is an administrator or a standard user?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Think I have dealt with this question before and could not determine was possible to get from the network. Could maintain this info in a table in the db.

    Get the username from network login with: Environ("username")

    Check this thread: http://www.tek-tips.com/viewthread.cfm?qid=415246
    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.

  5. #5
    injanib is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jan 2011
    Posts
    67
    I ended up going about it the long way, which I think is the better way. I ended up creating a users table and a login form. It was allot of work, but I can add/remove users, set specific access levels for each users, Force passwords to expire in 30 days, lock accounts after a number of invalid attempts, and even encrypted the passwords with MD5 encryption. It works great. Thanks for all your suggestions.

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

Similar Threads

  1. Replies: 7
    Last Post: 02-22-2013, 04:57 PM
  2. user level security and splitting access db
    By tomClark in forum Security
    Replies: 3
    Last Post: 02-06-2010, 04:28 PM
  3. Field Level Access
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-09-2009, 11:59 AM
  4. Controlled access to forms
    By Rameez in forum Forms
    Replies: 6
    Last Post: 06-18-2009, 02:18 AM
  5. Replies: 0
    Last Post: 06-11-2009, 09: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