+ Reply to Thread
Results 1 to 3 of 3

Tracking changes in MS Access data

  1. #1
    Forum Contributor
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    119

    Tracking changes in MS Access data

    Is there a way on how to track any changes made in MS Access database? If there are a lot of users changing data in database, the owner will know what are the data changes. Also it is possible to generate the audit tracker in different database or spreadsheet?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,619

    Re: Tracking changes in MS Access data

    Really depends on your db structure.

    Typically speaking, you'd ensure that you create interface for users to work on tables etc. And disallow direct edits.

    If you have this structure, you can add code in the interfaces to track changes made. Have a read of links.
    https://www.fontstuff.com/access/acctut21.htm
    https://blueclawdatabase.com/access-forms-audit-trail/
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    119

    Re: Tracking changes in MS Access data

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Advanced Excel / Access for Transfers tracking
    By jcchs2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2015, 12:53 PM
  2. Advanced Excel / Access for Transfers tracking
    By jcchs2 in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-01-2015, 12:47 PM
  3. Inventory Tracking - Excel or Access
    By OtterBoxing in forum Excel General
    Replies: 2
    Last Post: 06-23-2012, 03:30 PM
  4. Choice of application (Excel or Access) for attendance tracking
    By Ramzess in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2011, 03:52 PM
  5. Replies: 0
    Last Post: 05-31-2011, 11:27 AM
  6. Tracking access to Excel file through VBA rutine
    By scaffdog845 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-28-2009, 11:25 AM
  7. Tracking Access
    By Melissa in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1