activity logs of users

[jojo]

I am writing an Access 2010 program for a small business. They want the ability to track the actvity logs of users: if they added, deleted or edited.
Is there a capabilty to do this in Access?
I knw there is a macro that could be set to show the most recent user, but I don't think it could show what they did.
Any suggestions?
Thank you and thanks for all the great tips I've gotten at this forum.
(Windows &)
Jojo

 

[pr2-eugin]

Hello JoJo, there are several Audit Trail examples available on the internet that you could use.. A simple Google search listed a few..

* http://allenbrowne.com/appaudit.html - Allen Browne's implementation. A good documented resource.
* http://support.microsoft.com/default.aspx?scid=kb;en-us;197592 - Microsoft's version.

Look at the code and examples given, you should be able to take it from there..

 

[jojo]

Thenk you, pr2-eugin for your qick answer, and for the link. I plan to try coding that, and will let you know.
Thanks again. I have found so much helpful info on this great forum.
thank you all!
Jojo

 

[jojo]

Perfect!
I used Allen Browne's, creating a table containing the deleted records, any edited records with 2 versions before and after, and new records all with the date/time stamp and username as part of the record.
Awesome!
Thank you to pr2-eugin for the great answer.
Jojo

 

[pr2-eugin]

Glad to have helped.. Good luck..