who added that record?

[Salsa Man]

I am hoping that someone out there will be able to help me, I am about to start developing a number of databases which will require the tracking of who has entered either a record or added notes to a record. Is there an easy way to do this automatically along with the date?
Any help would be appreciated.

[Denburt]

What sort of environment are they in network wise? Do you know if they have a main server, are they using Active Directory?

[Salsa Man]

What sort of environment are they in network wise? Do you know if they have a main server, are they using Active Directory?

So far as i know its Windows with main server other than that I dont know, does that make a difference?

[Denburt]

Well it could, does your databases currently have security setup (logon screen) when they open? One more thing how are they currently logging into their PC or do they?

[ADezii]

I am hoping that someone out there will be able to help me, I am about to start developing a number of databases which will require the tracking of who has entered either a record or added notes to a record. Is there an easy way to do this automatically along with the date?
Any help would be appreciated.

One of my favorite methods is to create a Log File to monitor changes/edits/deletions, etc. Its simplist Format would be as follows:

Open "C:\<some directory>\LogFile.txt" For Append As #1
  '[MyKey] is a Primary Key that uniquely identifies the Record
  Print #1, CurrentUser & " modified Record ID# " & Me![MyKey] & " on " & Format(Now(), "ddd, mm/dd/yyyy @ hh:mm AM/PM")
Close #1

Output:

Admin modified Record ID# 1 on Fri, 03/23/2007 @ 11:57 AM

NOTE: All this, of course, assumes you have a Log On Procedure in place.

[Salsa Man]

Thanks for the help so far, I have not started to develope the database yet, so I have not added any security as yet, idealy I would like to be able to use the windows log on if that is possible.

[Denburt]

When Active Directory is in place I like using it to keep track of who's who and who is changing what. If AD is in place then you can add a reference in VBA to "Active DS Type Library"
Then you can use something like the following:

 
    Set sysInfo = CreateObject("ADSystemInfo")
    Set oUser = GetObject("LDAP://" & sysInfo.UserName & "")
    intUsr = InStr(sysInfo.UserName, ",")
    LName = Mid(sysInfo.UserName, 4, (intUsr - 5))
    FName = Right(sysInfo.UserName, ((Len(sysInfo.UserName) - intUsr) - 1))
    intUsr = InStr(FName, ",")
 
    FName = Left(FName, intUsr - 1)
    UsrNme = LName & ", " & FName
    UsrNme = UsrNme & " " & oUser.TelephoneNumber
 
   Me!Login = "Logged in as user name: " & Mid(Environ(29), InStr(1, Environ(29), "=") + 1)
    Me!UName = "Welcome: " & UsrNme
    Set sysInfo = Nothing
    Set oUser = Nothing