getting log names

[jofet]

is there a way to get the name of the pc (windows network login name) in a network that modified a certain record and put it in a table for reference?

thanks [sig][/sig]

 

[Vandys]

Yes, the network login name can be extracted and then stored in a field by using the advapi32.dll in a function. The function would look something like this:-
++++++++++++++
Private Declare Function apiGetLoginName Lib "advapi32.dll" Alias _
"GetLoginName" (ByVal lpBuffer As String, nSize As Long) As Long
+++++++++++++++
Function FGetName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetLoginName(strUserName, lngLen)
If lngX <> 0 Then
FGetName = Left$(strUserName, lngLen - 1)
Else
FGetName = &quot;&quot;
End If
++++++
'here you can add the code to save the value of FGetName into the table
++++++
End Function

Enjoy .... ;-)


Vandys [sig][/sig]