Code Samples for Businesses, Schools & Developers


Click the image to view a larger version


Updated 12 Sept 2018            

There are 3 common methods of getting the current user name in Access

1.   Environ("UserName")

2.   CreateObject("WScript.Network").UserName

3.   fOSUserName function by Dev Ashish
      As this includes API declarations, it needs to be adapted for 32-bit/64-bit systems using
      conditional compilation


#If VBA7 Then
         Public Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias _
                  "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long      
         Public Declare Function apiGetUserName Lib "advapi32.dll" Alias _
                  "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long  
#End If

Public Function fOSUserName() 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 = apiGetUserName(strUserName, lngLen)

    If (lngX > 0) Then
         fOSUserName = Left$(strUserName, lngLen - 1)
         fOSUserName = vbNullString
    End If

End Function

Of the 3 methods, the simplest uses the Environ function.
However it is possible to 'spoof' some Environ variables including the user name so this method can not be guaranteed to be accurate. This is the case for both ACCDB & ACCDE files

I am deliberately not going to explain here how this can be done.

As far as I am aware, the other two methods cannot be 'spoofed'.
Therefore, where it is important that the information isn't falsified, use one of methods 2 or 3.

As the WScript method does not need adapting for 32-bit/64-bit systems, that is the approach I would normally recommend.

Click to download an example database:
          GetUserName                Approx 0.4 MB (zipped)

This is a companion to my GetComputerName article.

Colin Riddington             Mendip Data Systems            Last Updated 12 Sept 2018

Return to Code Samples Page Return to Top