select user from ....

[William]

Help please. In an Oracle database I can identify the current user with the
statement "SELECT USER FROM DUAL;" Can I do something similar in MS Access?

 

[Allen Browne]

Help please. In an Oracle database I can identify the current user with
the
statement "SELECT USER FROM DUAL;" Can I do something similar in MS
Access?

The VBA function CurrentUser() returns the name of the user logged into the
database. (Note that if the database is unsecured, this will always return
Admin.)

For the code to get the Windows user name, see:
http://allenbrowne.com/ser-53code.html#GetNetworkUserName

 

[ghetto_banjo]

as another option, you can use VB code to get the Windows Username of
the person logged into the computer.

here is function that i have been using that i found online.

' Code Courtesy of
' Dev Ashish
'
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

 

[ghetto_banjo]

you also need to declare this first, on top of the VB code, so it
knows what dll to look at.


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



regards