detect user

[Irene]

i have a system. how can i detect the user who has been change the data or
update the data? i want it keep in a table and can be a proof when something
going wrong with the data.

 

[Keith Wilby]

i have a system. how can i detect the user who has been change the data or
update the data? i want it keep in a table and can be a proof when
something
going wrong with the data.

You can either use the CurrentUser function or you can grab the network ID
using this:

http://www.mvps.org/access/api/api0008.htm

Keith.
www.keithwilby.com

 

[Irene]

i have been trying this. but cant. i dont know y. what is API?

 

[Keith Wilby]

i have been trying this. but cant. i dont know y. what is API?

Paste the code into a module and save it. You can then call it from your
form's "Before Update" event to store the result in a table:

Me.txtUserName = fOSUserName

where "txtUserName" is the name of a text box bound to the field where you
want to store the name.

Keith.

 

[Irene]

hi keith,

thanks for ur help! but i stil have a question. is it need test on the
server? cos i'm copy the form and the table and put in my drive C to try, but
it didn't show anything. is it need put the table in the server, then the
form in the own pc? the result wil show the computer name or "admin" if he o
she is the admin for their own pc. sorry, because i'm new to this topic. hope
u stil can continue helping me. thanks!