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
#Else
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)
Else
fOSUserName = vbNullString
End If
End Function
Code Samples for Businesses, Schools & Personal Use
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
Code:
Get User Name
Screenshots
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 ...