Record modification dates & who did it

[Kila]

We have a database that we are sharing on a network How can I set up a table (or other method) that will automatically log when the database was last updated and who did it (the username). I would like to be able to run a report based on the modification dates of a particular user. Thanks in advance!

 

[ghudson]

Add two new fields to the table [ModifiedBy & ModifiedDate]. In the forms Before Update event you need to set the value for those two fields to = Environ("UserName") and = Now(). If you are using Access security then you could use = CurrentUser instead.

 

[ghudson]

The next big step would be to incorporate an Audit Trail into your db. Check out the sample I have posted @ Audit Trail.

 

[Kila]

Thanks!

That 1st part worked great! How can I get it to put in my username instead of Admin? I will try the Audit Trail later, after I finish a few other things with the database. Probably next week or so.

 

[ghudson]

The function I posted above Environ("UserName") will get their network name.

 

[jrjr]

Just an added note FYI,
I never did resolve my issues with Environ("UserName"). I believe it had to do with a malfunction in the install of Access itself. ghudson is correct in that it does pick up the network log on name when it works. In any event, check this thread for an alternative to using it:

http://www.access-programmers.co.uk/forums/showthread.php?t=88348

 

[Kila]

Using
= Environ("UserName")

instead of
= CurrentUser

worked great! Thanks!