Log time and date users update records

[Richie27]

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

[redbull]

Are you looking to log this information on a backend database? or built into the same mdb the user is on.

[Richie27]

Build it into the same one.

[redbull]

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.

[Richie27]

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!

[redbull]

Like trying to find a Corner in a round room.

[JoeM]

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