Windows User Name and Access

[MrMajik]

I would like to add a feature that would make the main form of my Access program aware of who the person is that opened the database.

Can Access be aware of the user ID (or login name) that a person used when they logged into the workstation or network domain?


Thank you,

MrMajik

There are 10 types of people in the world:
Those that understand binary and those that don't.

 

[fneily]

Would these help?
ACC2000: How to Place the User Logon Name in a Control on a Form or in the Title Bar of the Microsoft Access Window

http://support.microsoft.com/?kbid=210591

http://support.microsoft.com/?kbid=198755

 

[CautionMP]

MrMajik,
Did you try [tt]Environ("USERNAME")[/tt] (or [tt]Environ$("USERNAME")[/tt])? This will return the Windows Log On Id in Windows NT 4.0 or newer.

If you use ActiveDirectory for authentication you can even go a step further:

Public Function ADsFullName() As String
[green]'This function requires a reference to Active DS Type Library (activeds.tlb)
'Will work in any office application that will allow you to write and run a macro[/green]
Dim objIADsUser As ActiveDs.IADsUser
Dim strUserID As String, strComputerName As String
strComputerName = Environ$("COMPUTERNAME")
strUserID = Environ$("USERNAME")
Set objIADsUser = GetObject("WinNT://" & _
  strComputerName & "/" & strUserID & ",user")
ADsFullName = objIADsUser.FullName
Set objIADsUser = Nothing
End Function

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)