Tracking changes

[Guest]

Need help with tracking chagnes in a database. Can you track changes in a
database? Is this possibe? If so, can anyone help me with this. I would like
ot be able to track cahnges made.

Thanks

 

[Allen Browne]

Access cannot do this at the engine level.

However if all changes are made through forms, you can use the events of the
form to simulate this. See:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

You need to be comfortable with VBA code and the form events to do this.

 

[J. Clay]

If you have a need to track changes at the database level rather than the
interface level, you will need to use a database such as SQL Server that
allows for triggers at the table level. Otherwise, tracking changes made on
forms is the only option.

J. Clay