Results 1 to 3 of 3
  1. #1
    craig1988 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    82

    Create Audit trail of sorts

    Hi All

    I am creating an issue tracker and I would like to create an audit trail of sorts.



    All I need to capture is when the value of 3 fields are changed (What it was changed to, who changed it and when it was changed)

    For example

    The field is Status. It has a value of "OPEN", a user who is recognised within the database (the username will be passed through after they log on) changes the status to "RESOLVED". I would like a record of that change appended to an Table (tblAudit). It would need to record the old status, the new status, the user, the time, the ID of the record that was changed.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,422
    If you are NOT editing directly in the data...you can.
    EX. User edits record key 101
    this action puts that record into an 'edit' table (not the main table where its is really strored)
    changes are made, then a SAVE button is clicked.
    at this point you can record to the audit table your interested fields, STatus, User, etc. using the key field to pull the BEFORE values (still in the MAIN tbl), and the working table AFTER values.
    then update changes to the MAIN table from the working table.

  3. #3
    craig1988 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2014
    Posts
    82
    Hi ranman256

    The example you gave is pretty much what I am looking for.

    How do I pull the BEFORE values? How are values appended to the "edit" tbl?

    Thanks

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

Similar Threads

  1. Audit Trail and Reporting
    By CementCarver in forum Programming
    Replies: 2
    Last Post: 05-29-2013, 07:42 AM
  2. Replies: 2
    Last Post: 02-09-2013, 12:39 PM
  3. Audit Trail
    By bigroo in forum Programming
    Replies: 4
    Last Post: 02-22-2012, 07:55 PM
  4. audit trail
    By slimjen in forum Forms
    Replies: 1
    Last Post: 10-13-2011, 01:52 PM
  5. Audit trail question #2
    By jpkeller55 in forum Access
    Replies: 9
    Last Post: 09-13-2010, 05:55 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 - Senior Forums