Is there a way to track changes made in an Access 2002 database?

M

Maureen

Can a log be created that shows a name was changed on a certain date at a
certain time by a certain user, etc.?
 
T

Tony Toews [MVP]

Maureen said:
Can a log be created that shows a name was changed on a certain date at a
certain time by a certain user, etc.?
Click to expand...

There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://allenbrowne.com/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
M

Maureen

I tried the Northwind.mdb example first, and it worked great except the
change info wasn't saved in the table. It only shows up on the form. Did I
do something wrong?

Thank you for your help.
 
Top