Log File for Access 97

J

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
 
T

Tom Wickerath

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
 
Top