Log File for Access 97

[John Cole, Jr.]

I have a multi-user database that requires users to access the same
records multiple times in a form filling out a different field in the
record each time. I need to setup a log table to programmatically list
user, timestamp, field changed, old value and new value? Thanks in
advance for the help.

JC

 

[Guest]

Hi John,

Try this tutorial offered by MVP Allen Browne:

Creating an Audit Log
http://allenbrowne.com/AppAudit.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a multi-user database that requires users to access the same
records multiple times in a form filling out a different field in the
record each time. I need to setup a log table to programmatically list
user, timestamp, field changed, old value and new value? Thanks in
advance for the help.

JC