audit Log

[mwabbe]

http://allenbrowne.com/AppAudit.html

has anyone ever gotten this to work?


because it is not logging for me. thanks.

[RuralGuy]

Did you mark this thread as Solved in error?

[mwabbe]

no, i just figured it out.

[RuralGuy]

Good. Just checking.

[mbake085]

I think I already know the answer to this... Is there any similar way of tracking changes at the table level instead of if users make edits through the forms?

[mwabbe]

i have no idea im terrible at code im just going to leave it at the form level

[RuralGuy]

I think I already know the answer to this... Is there any similar way of tracking changes at the table level instead of if users make edits through the forms?

Only if you use a more robust BackEnd like SQL Server. There are no triggers at the table level in pure Access.

[mbake085]

Thats what I thought. Thanks for the help.

[thekruser]

Thinking of implementing this in my db. Any thoughts as to it's usefulness? Does it work well?

[mwabbe]

works great. there a few downfalls like cascading updates and deletes will not log but it is really good and easy to implement

[thekruser]

Thank you. I will implement it then. Something is better than nothing when you are in a multi-user environment.

[mwabbe]

yeah def. it logs user and a very precise time stamp as well

[thekruser]

Does it log when a record is created? Right now I am in the process of adding a field at the end of every table for username of the person who created the record. If it logs this as well, I am currently wasting my time.

[thekruser]

Better question...does it allow for logging changes made in a subform? The majority of my database is subforms.

[mwabbe]

im not sure i dont have any subforms where this in effect. i was reading another post and i could be wrong but i think i saw that the allenbrowne audit log does work with subforums because someone made their own and could not get it to work