Database events log

[H. Martins]

I must find some solution so that what happens in database can be
traced back.

Not every form need to be logged. I thought I could write a function
that would append to an existing table (not related to other tables),
or other database (probably more complex), some data as: UserName,
FormName, WhateverControl.ControlSource_Name, OldData, NewData, etc.

I think I can write the function in a Module (is is the right place?)
and ?include? it in other form's VBA the old C Include faction.

The logging function would be called with logging arguments triggered
by OnMouseDown and AfterUpdate or OnGetFocus OnLostFocus ...

Any advise is welcome.

Thanks
Henry

 

[Linq Adams via AccessMonster.com]

Here's a link to Allen Browne's Audit Trail hack:

http://allenbrowne.com/AppAudit.html