Tracking Changes in Access

[johnny boy]

Hi,
Is there any simple or easy way to track changes in Access in between
saving access files?

I think the answer is probably no but maybe someone can help.

John

[pietlinden]

what kind of changes are you talking about? Structural changes (use
Visual Source Safe or something like it) Data changes - not inherently.
(Well, not like SQL Server, which logs everything so you can roll
changes back). but maybe this will help:
http://www.allenbrowne.com/AppAudit.html

[johnny boy]

Thanks - yes data changes

[(PeteCresswell)]

Per johnny boy:

Thanks - yes data changes

If it's in a JET back end, my experience has been that it is not trivial.

I'd lean on the users to make sure they really need this and it isn't just
something that came to mind and sounded like it might be good for CYA purposes
some day.

When I've done it, I made the form based on work tables with a "Browse" and
"Edit" mode.

When the user clicks Save, I run code that compares each field in each table to
what's in the production DB and writes records to the audit table accordingly.
It's not exactly rocket science, but it is a *lot* of additional coding.
--
PeteCresswell