Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015
    Posts
    17

    Unanswered: Keeping track of database updates

    Hi

    I want a way of keeping track of when a database is updated. Ideally I'd like a field in the main form of a database to update to today's date every time that a field in a record is altered.

    Is there a simple way of doing this?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    create a trigger in ms access
    set a control to be the current datetime
    or go the whole hog and use an audit teail such as suggested by Allen Browne and others... google ms access audit trail
    I'd rather be riding on the Tiger 800 or the Norton

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
  •