Results 1 to 2 of 2
  1. #1
    V760838 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    10

    Question How to make different log in for different people

    Hi,

    I am making a database for issue and returning of tools to individuals of a company. I want to make a user name & password for each individual so that no other person can draw tools against his name. Basically, I want that he should have access to his own records only. How can I achieve that ?

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    There are third-party tools that will help with this, like our LASsie add-on (http://www.peterssoftware.com/las.htm), but basically you'll have to have a sign-on form for each user to sign on to the application, then you'll need to save that user sign on as a global variable, or in a table. You could use the windows user name (see this function: http://access.mvps.org/access/api/api0008.htm), but I've found that often these user names are shared on a network. You'll also need to have a field in your table for the user name and your forms should filter for the current logged in user when the form opens.

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

Similar Threads

  1. Display list of people waiting
    By foxtet in forum Forms
    Replies: 1
    Last Post: 06-21-2011, 12:34 PM
  2. Number of people able to Access DB
    By noelrobb in forum Forms
    Replies: 4
    Last Post: 02-07-2011, 08:01 AM
  3. Replies: 0
    Last Post: 12-28-2009, 12:14 PM
  4. equipment and people check in and out
    By aaronlalonde in forum Access
    Replies: 0
    Last Post: 07-29-2009, 08:28 PM
  5. Best way to organize a small database of people?
    By Orabidoo in forum Database Design
    Replies: 1
    Last Post: 06-09-2009, 10:13 PM

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