Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Location
    Lancaster PA, USA
    Posts
    33

    Unanswered: audit trail

    A user is requesting that I devise an 'audit trail' for an access database. Meaning they want a way to track the changes each user makes. I'm not entirely sure how I would go about doing something like this or if it is even possible. From what I've gathered from google I could add an extra table and use it as a log appending user names and dates to it using the after update method. I wasn't sure if there was an easier way to go about attempting this that I might be missing. Any insight will be greatly appreciated. Cheers!
    Last edited by Werner700; 09-05-07 at 12:43.

  2. #2
    Join Date
    Dec 2005
    Location
    Lancaster PA, USA
    Posts
    33
    With a little more digging I managed to find this:
    http://support.microsoft.com/kb/197592

    Which so far appears to be working. Not sure how I would be able to make audit trail even more detailed though. Very informative if you're looking to do something similar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •