History log

[V Ramos]

Is it possible in Access/VBA to create a log of all edits done on a record?

I'm tasked to create a module that automatically saves to a garbage file all
records edited by a user. This way, i can recover the original records from
the garbage file if the user made a mistake or accidentally deleted the
record.

Any ideas on how to implement this?

Thanks in advance...

 

[Allen Browne]

Access does not to this natively, but it is possible to use the form events
if all your changes are made through forms.

For details of how to log inserts, deletes, and edits, see:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

 

[V Ramos]

Access does not to this natively, but it is possible to use the form events
if all your changes are made through forms.

For details of how to log inserts, deletes, and edits, see:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




Many thanks Allen, i think this is what i really need.