Tracking Changes In Form

[Help.Chris]

Hi everyone,

I am looking into having a log of record changes in an Access 2000 database.

I have looked in different sites and have discovered the currentuser() function, but I know staff in this business would abuse this.

Is it possible to reference the logon name for nt/2000, and if possible the computer name. These would be brilliant, as I could then find out where someone was sat, and there real user name.

If anyone has any idea on this is would be greatly appreciated.

Thanks for any help.

Chris

 

[charityg]

microsoft has written a few articles about what you are looking for. The information you want is contained in the LDB file that Access creates. Here's a link to get you started.
http://support.microsoft.com/support/kb/articles/Q136/1/28.asp?LN=EN-US&SD=gn&FR=0&qry=read%20ldb&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97