Creating a Change Log

[copernicus]

I am trying to create a change log in access 2007 so that whenever a record is updated via a form, all of the original values of the table are added to ChangeLog Table, and the changes are then applied to the main table. I have done something similar in access 2010, but some of the functions used are new to 2010 (or maybe it's just the difference in the layout that is confusing me). Can anyone point me in the right direction here? Thanks for any help.

 

[Uncle Gizmo]

all of the original values of the table are added to ChangeLog Table,

Search the forum for “audit trail” and/or the term “old value” or possibly “oldvalue”

 

[copernicus]

Search the forum for “audit trail” and/or the term “old value” or possibly “oldvalue”

Thanks for the reply UG! I ended up finding exactly what I was looking for at: (no link supplied cause I can't!) But Google Allen Browne Creating an Audit Log and there is some good info on the subject for pre 2010 access users.

 

[missinglinq]

Here's that link to Allen's tutorial on the subject:

http://allenbrowne.com/AppAudit.html

As I'm sure you've already figured out, this task is not for the faint-of-heart!

Linq ;0)>