Track the Username when a record is changed HELP!!

On the before update event procedure of the form I have written the following:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11019-track-the-username-when-record-changed.html

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[EditDateTime] = Now()
Me.[Edit_USERID] = CurrentUser()

End Sub

The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at home
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11019
and on the network and it is driving me CRAZY!!

The Options in Access are correct and have my name as the User Name.

Can someone please help me out here??

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Admin is the default for Access if no user level security has been set.
Until you set this then you won't be able to do what you want.
"ScubaDee" wrote in message
news:229CBB34-5194-49D3-85FD-5EECE404D413@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11019
> On the before update event procedure of the form I have written the
> following:
>
> Private Sub Form_BeforeUpdate(Cancel As Integer)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11019
> Me.[EditDateTime] = Now()
> Me.[Edit_USERID] = CurrentUser()
>
> End Sub
>
> The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at
> home
> and on the network and it is driving me CRAZY!!
>
> The Options in Access are correct and have my name as the User Name.
>
> Can someone please help me out here??

Perhaps you would do better by grabbing and using the Windows username:

http://www.mvps.org/access/api/api0008.htm
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11019
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"ScubaDee" wrote in message
news:229CBB34-5194-49D3-85FD-5EECE404D413@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11019
> On the before update event procedure of the form I have written the
following:
>
> Private Sub Form_BeforeUpdate(Cancel As Integer)
> Me.[EditDateTime] = Now()
> Me.[Edit_USERID] = CurrentUser()
>
> End Sub
>
> The problem is the USERNAME is ALWAYS "Admin", this occurs on my PC at
home
> and on the network and it is driving me CRAZY!!
>
> The Options in Access are correct and have my name as the User Name.
>
> Can someone please help me out here??