Tracking changes to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I maintain a database that is shared with several other people. My boss has
just decided that he would like a report that shows the exact times that
changes are made to the main table in the database and what those changes
were. Is this possble? I don't know much about programing, so if someone
else has done this I could use all of the help you can give me. I am not too
proud to copy someone else's work, especially since this seems to be way over
my head.

Thanks for your help.
 
Access does not provide this kind of logging information for you, but if all
changes are made through forms (not directly into the tables or queries, and
not through action queries), you can use the events of the form to create a
complete history of inserts, deletes, and edits.

Details in:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

You will need to be comfortable with VBA to implement this. Be sure to make
the tables exactly as indicated. An extra field, a missed field, or a field
in the wrong order will prevent it from working.
 
Back
Top