Results 1 to 4 of 4
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    How to create a Multi User login with user levels

    I need to create a multi-user with user levels such as admin, and read only access database I created. I curently made a login with a password to get in the database but I want to only allow certain people to just have read-only access. I may have to discard the login I created that I found on line to make this work. I have Access 2007 and I have the database split (FE and BE).

    Is there a vbscript with directions that I can use to pull their network login as their username and the password I supply them which will give them the appropriate security level I set for them?

    Thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Can get the network user name with: Environ("UserName") - yes, type it exactly as shown. What I do is get the network user name to control user privileges on forms (disable command buttons). I don't have password because I assume if the network verified password they are valid users. Check this http://www.go4expert.com/forums/showthread.php?t=208
    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
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    I need to be able to build the vba coding, form and table to give the user the ability to login set by the windows logon and the permissions I set.

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

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

Similar Threads

  1. Display user's database or record after login
    By stoey in forum Programming
    Replies: 13
    Last Post: 09-15-2011, 11:18 AM
  2. Multi User Updation. Help!
    By Mohideen in forum Access
    Replies: 2
    Last Post: 08-26-2011, 06:00 PM
  3. How to handle multiple user levels
    By nkuebelbeck in forum Access
    Replies: 2
    Last Post: 08-23-2011, 10:56 AM
  4. multi-user question
    By Killerbee in forum Forms
    Replies: 8
    Last Post: 05-03-2011, 02:37 PM
  5. Login and user levels
    By seanog2001 in forum Forms
    Replies: 0
    Last Post: 10-27-2009, 05:13 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