Results 1 to 5 of 5
  1. #1
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58

    Restricted Access - Admin v. User

    Good morning.

    I've setup my db with a Logon screen that prompts end users for a userID and password to gain access to the db. This will ultimately either be "Administrator" or "Guest".

    Once successfully logged in, the Switchboard for the db is prompted, and several forms are available for users to run reports.

    My goal here is to restrict "Guest" access on the Switchboard (and overall db) so they are not able to see (or use) the forms that are for data entry (Administrators only). Only want them to be able to see/use forms on the Switchboard for running reports pertaining to their respective business needs.

    I don't even know where to begin on this. I've searched through the forum and seen some chatter on this, but most of it went right over my head.

    Anyone willing to push me in the right direction? Help would be much appreciated.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a link to my preferred method of doing what you would like to do.

    http://www.mrexcel.com/forum/showthread.php?t=248191

    I have used this method many times successfully. It is a detailed tutorial but once in place, is very effective.

    Alan

  3. #3
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58
    Thanks, Alan. I'll give this a read and a try. Much appreciated.

  4. #4
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58
    Alan,

    Any tips for converting the code you referenced to Access 2010, specifically the Navigation form? I'd prefer to use the Navigation interface that I created as opposed to a list that the referenced code uses.

  5. #5
    need_help12 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    58
    disregard....

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

Similar Threads

  1. Restricted Access Login Code Error
    By need_help12 in forum Programming
    Replies: 6
    Last Post: 04-27-2012, 08:48 AM
  2. Replies: 1
    Last Post: 08-10-2011, 12:04 AM
  3. user restricted query
    By adidashawn6 in forum Queries
    Replies: 1
    Last Post: 01-06-2011, 11:24 AM
  4. How to overcome a deadlock in Admin privilege
    By Babu1983 in forum Security
    Replies: 1
    Last Post: 09-02-2010, 12:09 PM
  5. Admin Rights
    By Keri in forum Security
    Replies: 4
    Last Post: 11-18-2005, 11:18 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