User Identifier Approach

[burrina]

It was recently suggested to me that it would be better to use WScriptNetwork than Environ UserName
Is WScrript just for a network environment or is better or what?

[HansV]

Using WScript, or the WNetGetUserA Winows API function, has the advantage that the user cannot alter it, unlike Environ("username").
So the former are more secure.

[burrina]

Thanks, that's what I though but wanted to confirm.

[burrina]

Just to be sure, I modified the code to use this. Is this correct?
CurrentDb.Execute "INSERT INTO tbllogintime (logintime) VALUES ('" & WScriptNetwork("username") & "')", dbFailOnError

[HansV]

No, it doesn't work like Environ. WScript is a VBA library, Network is an object in that library, and UserName is a method of that object. You have to create the WScript.NetWork object:

CurrentDb.Execute "INSERT INTO tbllogintime (logintime) VALUES ('" & CreateObject("WScript.Network").UserName & "')", dbFailOnError

[burrina]

Ok, I understand now.
Thanks,