Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracking changes in a table (ACCESS 2003)

    Subject edited by HansV to make it a bit more descriptive than "MS ACCESS"

    I have a database that is out on a network and is being used by multiple users. I have a feeling that some of the users are editing data from the tables to manipulate the database. Is there a way to track the last user who updated a record and what changes were made?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tracking changes in a table (ACCESS 2003)

    If users are allowed to edit data directly in tables or queries, there is nothing you can do, for Access does not have triggers at the table level.

    If you apply user-level security, you can ensure that users can only edit data through forms, and there you can use VBA code to keep track of changes.
    See Allen Browne - Creating an Audit Log, and if you want to know more about user-level security, see WendellB's tutorial The Secrets of Security.

  3. #3
    Lounger
    Join Date
    Mar 2004
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking changes in a table (ACCESS 2003)

    Thank you very much.

Posting Permissions

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