How can I get a report on the number of field changes made in Acce

[Guest]

I need to be able to do an accounting of all the changes made to a database
in a given month. Is there a way to keep track of all the field changes made
to a database?

 

[Allen Browne]

No. Access (JET) does not provide transaction logging.

If all changes are made through forms, you can use the events of the form to
log them. Details:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[Guest]

Try here at Rogers access files, he has a mdb to download called audit trail.

HTH

 

[George Nicholson]

There is a 3rd Party tool, CompareWiz, that I have used to document changes
between mdb files. It would only be able to tell you that a field had been
changed between file dates (and maybe the date of the last change) but it
wouldn't be able to tell you how *many* times a field had been changed. It
answers the question "what's different?" without much more detail than that.
I haven't used it in a while, so take this with plenty of salt

http://www.softwareaddins.com

HTH,