Track who added new records

[m17347047711116]

Have a database for which i have setup a password to open the database.

it has been requested that i identify who is making entries to the database for data entry mistakes tracking.

Thinking i could set up some sort of unique passwork login for each user but not sure if i would be able to determine later who was logged on and made the entries ?

Can anyone help
Thank you

 

[Hayley Baxter]

Have a look at this post there is an example attached to find the current user.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30421&highlight=get+userid

Hay