Results 1 to 4 of 4
  1. #1
    sssandhya89 is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2013
    Posts
    15

    Audit log in function! urgent please!

    Hey guys,
    I am new to this forum, i want to create an audit login function for the MS access database that i've created, i've created user-forms for logging in to the DB for which the usernames and passwords are stored in an access database and every time the user logs in he gets validated if the username and password matched the record in the access DB, now i want to know who logged in last and at what time, can you please help me create a function for it or tell me what to do?

    Sandhya

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Presuming you have a table to store that data, create an append query that appends a record into it using the login form for the user, and execute it from your login code.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    sssandhya89 is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2013
    Posts
    15
    Thanks. Well, I need to know the time of when they logged in last too, what do i do for that?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Well, I'm suggesting a table that records each login, so you would just look it up.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 02-09-2013, 12:39 PM
  2. Audit Log
    By Darkladymelz in forum Programming
    Replies: 15
    Last Post: 03-06-2012, 11:36 AM
  3. Audit Trail
    By bigroo in forum Programming
    Replies: 4
    Last Post: 02-22-2012, 07:55 PM
  4. audit Log
    By mwabbe in forum Access
    Replies: 42
    Last Post: 05-30-2011, 07:23 AM
  5. Replies: 0
    Last Post: 07-15-2010, 11:26 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