password indicate what user in database edited, deleted, ect?

[jojomac]

I have a database i've developed and worked on improving for years. I have
no passwords set up. I would like to be able to see who entered a record,
deleted, edited, etc. Is there a way to do this? I'm using microsoft office
professional 2003.

 

[Gijs Beukenoot]

From jojomac :

I have a database i've developed and worked on improving for years. I have
no passwords set up. I would like to be able to see who entered a record,
deleted, edited, etc. Is there a way to do this? I'm using microsoft office
professional 2003.

If users are forced to log on before using the computer you can use the
GetUserName or GetComputerName API to get the current user. On the
beforeupdate of the form, run the function and store that username in a
field in the table (although it would be nicer (using less space) to
create a separate usertable and only store an ID)
This breaks, naturally, when several users are using the same PC
without logging off and on (as a different user).