Hello everybody,
I am looking for a bit of advice. I want to store the time and user who updates a table. tm_update, user_id stored in each table.
Any advice on the best approach would be super.
Thanks,
Rich
Hello everybody,
I am looking for a bit of advice. I want to store the time and user who updates a table. tm_update, user_id stored in each table.
Any advice on the best approach would be super.
Thanks,
Rich
Are you looking to log this information on a backend database? or built into the same mdb the user is on.
Build it into the same one.
I hope this helps, http://allenbrowne.com/AppAudit.html I tried using this, but I needed a back end scenario. Either way, AllenBrowne is a genius.
And if you want to track form usage, http://allenbrowne.com/AppLogDocUse.html
I was able to modify the last one to do an update query whenever a user clicks a command button on the form.. It updates the back end. I can see who is signed in, and what button they clicked at what time. I could have pulled a lot more information but thats all I needed.
Last edited by redbull; 06-13-2012 at 08:05 AM. Reason: update
Hey thanks. I will have a gawk and let you know.
Just been dragged back into a db I thought was finished! Ahhhhhhhhhh,............ it never ends!
Like trying to find a Corner in a round room.
I am a longtime Access programmer who just joined this forum yesterday (I am active in other forums). I was checking out some information on this site, and came across this thread in the Code Repository, which looks like it might also have what you are looking for: https://www.accessforums.net/code-re...rds-10212.html