Logging changes

  • Thread starter Thread starter RW
  • Start date Start date
R

RW

How is the best way to log all changes done to data in a table in Access?

What I want is (another) table where all UPDATEs, DELETEs and INSERTs are
stored.

Is there any 'built-in' mechanism for this, or will I have to make my own?

Thanks any help on this!

- Randi
 
Sorry, no "in-built" and you have to make your own. You
will need to force the users to use Forms for ALL data
entry & edit so that you can use the Events of the Form to
run the required code to write the Audit trail.

You should be beware that you database will grow very
quickly with the Audit trail.

Allen Browne has an article on Audit Trail at:

<http://users.bigpond.net.au/abrowne1/AppAudit.html>

HTH
Van T. Dinh
MVP (Access)
 
Back
Top