By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,714 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,714 IT Pros & Developers. It's quick & easy.

Obtain OS username

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

P: n/a
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


Nov 13 '05 #4

P: n/a
"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.
Nov 13 '05 #5

P: n/a
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.

Nov 13 '05 #6

P: n/a
"Alan Webb" <kn*****@hotmail.com> wrote:
Lot's more there than username.


Hell yeh!
Nov 13 '05 #7

P: n/a
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
Nov 13 '05 #8

P: n/a
"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
Nov 13 '05 #9

P: n/a
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 ;-)
Nov 13 '05 #10

P: n/a
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
Nov 13 '05 #11

P: n/a
Trevor Best <nospam@localhost> wrote:
Not by my users they can't ;-)


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


The latter :o)
Nov 13 '05 #12

P: n/a
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
Nov 13 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.