Windows NT Integrated Security

[dkao99]

I use "Use Windows NT integrated security" option in .adp to connect to the SQL database. I like to get the user's network login id, who is running the app, to fill a column in a record. Any help is appreciated.

[MMcCarthy]

I use "Use Windows NT integrated security" option in .adp to connect to the SQL database. I like to get the user's network login id, who is running the app, to fill a column in a record. Any help is appreciated.

I've moved your question from the articles section to the forum.

Check out this tutorial

Function to return Username of current user

[ADezii]

I use "Use Windows NT integrated security" option in .adp to connect to the SQL database. I like to get the user's network login id, who is running the app, to fill a column in a record. Any help is appreciated.

A little API call should be able to retrieve the Current User's Network Log-On ID:

1. Declare the API Function in a Standard Code Module:
   

   Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

2. Call it in an appropriate manner:
   

   Dim lpBuff As String * 25, ret As Long, UserName As String
    
   ret = GetUserName(lpBuff, 25)
   UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
   MsgBox "The currently Logged On User is '" & UserName & "'"