Results 1 to 3 of 3
  1. #1
    WickidWe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Posts
    123

    Create Login With 2 Access Levels

    Hi I want to create a login to access a database
    All it needs is Username Password to be entered


    In the table it will have a Username, Password and level.

    I need level 2 to access only forms
    and Level 1 to access backend with no restrictions.

    Is this hard to setup?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    There used to be a thing called User Permissions that was available in previous versions of Access. I believe the only way to manage this is through a combination of VBA and custom menus OR you can create an executable file as an FE and use Network permissions to restrict access to the BE. So yes, rather involved.

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    Try the Program as Guide to Create User and Their Right
    User Administrator
    PAssword admin
    Attached Files Attached Files

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

Similar Threads

  1. create form login with pasword
    By thomanmpku in forum Security
    Replies: 2
    Last Post: 08-29-2013, 06:32 PM
  2. Replies: 2
    Last Post: 01-26-2013, 11:38 PM
  3. Having trouble visualizing how to create a login
    By seth.murphine in forum Access
    Replies: 19
    Last Post: 04-11-2012, 03:24 PM
  4. Replies: 3
    Last Post: 09-22-2011, 03:35 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