Mendip Data Systems

Database applications for businesses and schools


#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

Code Samples for Businesses, Schools & Personal Use

Updated 12/09/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



Get User Name


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


NOTE: 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 (ACCDB & 32-bit ACCDE both included):


          UserNameTest                   Approx 0.4 MB (zipped)



NOTE: This is a companion to the GetComputerName item


Click the image to view a larger version ...

Return to Code Samples Page