Obtain OS username

[Mark Reed]

All,
I have spent some time looking for an answer on this and as of yet have
not found one. Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB? The platform is XP pro.
I'm assuming that it can be done because I have noticed that if try to open
an Excel document stored on the network server, a pop-up appears showing me
the username of the person that has it open.

TIA,

Mark

[Mark Reed]

just to add to my original question, I want to be able to record who has
logged in and out of the frontend and at what time. I have used MS workgroup
security to secure the DB and didn't really want to create my own security
to be able to log this.

Cheers again,

Mark
"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:U%************@newsfe4-gui.ntli.net...

All,
I have spent some time looking for an answer on this and as of yet have not found one. Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB? The platform is XP pro.
I'm assuming that it can be done because I have noticed that if try to open an Excel document stored on the network server, a pop-up appears showing me the username of the person that has it open.

TIA,

Mark

[Brad\(ey]

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:J2*************@newsfe4-gui.ntli.net

just to add to my original question, I want to be able to record who
has logged in and out of the frontend and at what time. I have used
MS workgroup security to secure the DB and didn't really want to
create my own security to be able to log this.

CurrentUser()

--
regards,

Bradley

[Terry Kreft]

First question you asked
http://www.mvps.org/access/api/api0008.htm

Second Question
CurrentUser function
--
Terry Kreft
MVP Microsoft Access
"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:J2*************@newsfe4-gui.ntli.net...

just to add to my original question, I want to be able to record who has
logged in and out of the frontend and at what time. I have used MS workgroup security to secure the DB and didn't really want to create my own security
to be able to log this.

Cheers again,

Mark
"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:U%************@newsfe4-gui.ntli.net...

All,
I have spent some time looking for an answer on this and as of yet

have

not found one. Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB? The platform is XP pro. I'm assuming that it can be done because I have noticed that if try to

open

an Excel document stored on the network server, a pop-up appears showing

me

the username of the person that has it open.

TIA,

Mark

[Keith Wilby]

"Mark Reed" <ma*********@ntlworld.com> wrote:

Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB?

I'm on A97 on an NT4 network and use the "Environ" function:

strUserName = Environ("USERNAME")

Regards,
Keith.

[Alan Webb]

Keith,
Very nice. Lot's more there than username. Something fun to do this
weekend! Kewl.

"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn************************@10.15.188.42...

"Mark Reed" <ma*********@ntlworld.com> wrote:

Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB?

I'm on A97 on an NT4 network and use the "Environ" function:

strUserName = Environ("USERNAME")

Regards,
Keith.

[Keith Wilby]

"Alan Webb" <kn*****@hotmail.com> wrote:

Lot's more there than username.

Hell yeh!

[Tony Toews]

Keith Wilby <ke*********@AwayWithYerCrap.com> wrote:

Is there any way in which the username used to log onto a
network can be retrieved using an Access 2000 DB?

I'm on A97 on an NT4 network and use the "Environ" function:

strUserName = Environ("USERNAME")

But environment variables can be changed by the user thus spoofing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tony Toews]

"Alan Webb" <kn*****@hotmail.com> wrote:

Very nice. Lot's more there than username. Something fun to do this
weekend! Kewl.

Ayup, I now allow use of any of those variables in the Auto FE Updater.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Keith Wilby]

Tony Toews <tt****@telusplanet.net> wrote:

strUserName = Environ("USERNAME")

But environment variables can be changed by the user thus spoofing.

Not by my users they can't ;-)

[Trevor Best]

Keith Wilby wrote:

Tony Toews <tt****@telusplanet.net> wrote:

strUserName = Environ("USERNAME")

But environment variables can be changed by the user thus spoofing.

Not by my users they can't ;-)

Because of your policies or because of your users? :-)

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Keith Wilby]

Trevor Best <nospam@localhost> wrote:

Not by my users they can't ;-)

Because of your policies or because of your users? :-)

The latter :o)

[Tony Toews]

Trevor Best <nospam@localhost> wrote:

But environment variables can be changed by the user thus spoofing.

Not by my users they can't ;-)

Because of your policies or because of your users? :-)

<chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm