Results 1 to 2 of 2
  1. #1
    katkth7533 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    5

    Adding Login/ Password function to Define What Data a User Sees

    I am creating a task list database for multiple users where tasks will be assigned to specific people to complete (I will call that person the "responsible lead"). The task originator and responsible lead fields will be drop down menus of defined names. My question is this: how do I design this so that there is a login/ password required when the database is opened, and based on the login entered, that user will only see those task items that they either originated or have been assigned to complete as responsible lead? For example, let's say there are 100 tasks in the entire database and "Bob Jones" is assigned the responsible lead on 10 of them and "Bob Jones" was the originator of another 20. "Bob Jones" would log in and only see those 30 tasks that are associated with him. I plan to have all the tasks in the database in 1 table and the users will add/ edit/ update the task through a form. I am a little rusty in Access - my last database was written about 8 years ago so I am looking for a direction to start. Thank you so much.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This is a common topic in forum. Search should return many threads.

    Records would be filtered by user ID. This means the data table needs a field that stores user ID. The filter can be built into query or code can apply filter to form.

    Can require user to log in with ID and password. I store user ID on a form (main menu) that never closes so can reference at any time.

    I also use code to pull the user ID from the network. I use Environ("USERNAME") - yes, type exactly as shown - to get the user's network login username. If the network username is not the ID saved with data, will need a Users table that has the network username and their database ID and do a lookup to get the ID based on username. Only new users ever see the login form, once they are in the Users table, never login again.
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-28-2014, 01:43 AM
  2. Replies: 3
    Last Post: 02-05-2014, 04:01 PM
  3. Replies: 2
    Last Post: 01-26-2013, 11:38 PM
  4. Replies: 1
    Last Post: 12-30-2012, 07:57 PM
  5. Problem with User Login and Password
    By sk88 in forum Access
    Replies: 3
    Last Post: 12-16-2011, 08:11 AM

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