Who logged in???

[Charles]

Hi. I need to know the user who logged into the
application. Is this windows programming or SQL? One
login is used through Win2000 as a result I suspect that
it is windows programming but I don't know. What I know is
that the user can be viewed via File, Connection, All,
Userid but how to get this in code.

HELP........


Charles

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You're last sentence seems to indicate that you are using the network
admin tools to "see" who is currently in a folder/file. Since you
posted this question to access.adp.sqlserver newsgroup I'm assuming
you want the solution for that group of software.

You can get the current user name by using the T-SQL function
Current_User(). If you're talking about the Win2000 logon name - when
using VB/VBA you have to use an API call to get it. There is an
example here (Access VBA):

http://www.mvps.org/access/api/api0008.htm


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQB2Zy4echKqOuFEgEQJ0sgCg+YNymaTVELI7SsxUQhGtnANsRoMAoM01
wZ7na4XWnXM+pcEmuYwkvSmx
=sEPf
-----END PGP SIGNATURE-----