MS Access 2003 - Determine User ID from System when User opens MS access Application

I have a MS Access 2003 Application that the user opens and then can submit innformation and do other business while in my MS Access application.

I would like to determmine the user ID from the server when the user opens the MS Access 2003 application without having the user enter a login id.

Question: What code or process can I use to determine who is logging into my MS Application when the user opens the MS Access 2003.

Thank you for your guidance.
Ldufresne
 
 
LVL 1
Lou DufresneIT Business Analyst CSM / Project ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
environ("username")
0
Dale FyeCommented:
There is an API call you can call too, but using environ is easier.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
API is the ticket.  Environ can be gotten around easily.  See:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23071163.html

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dale FyeCommented:
Jim,

By "gotten around" do you mean that an unscrupulous person can change the value of that environment variable, and thereby potentially bypass security measures that are keyed to it?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<By "gotten around" do you mean that an unscrupulous person can change the value of that environment variable, and thereby potentially bypass security measures that are keyed to it? >>

 Yup.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
and BTW, sorry about posting basically a dup comment.  I didn't realize that "API Call" in your comment was an actual link.

  Thought it was one of those words that automatically gets recongized as a term and under linned (visiting too many web sites lately).

Jim.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I agree with Jim that the API method is the most secure/accurate way.
0
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Both of these solutions provided me with the best way to accomplish what I need to do. "Fyed" gave the group the sugestion about API and JDettman provided me the link on how to code it .
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Actually, fyed also give you a link to some code on the MVP site, although it's not obvious from the comment.

  If you click on it, you will get to the MVP site where you will find code similar to what I posted.

  Would you like the question re-opened so you can assign fyed the solution?

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  Just saw that the MVP code is only for the username.  My code does both username and computer name.  Probably want to stick with that.

Jim.
0
Dale FyeCommented:
Jim,

Stop being so galant and just accept the points!

Dale
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Dale,

  Fair is fair... you were there first.

Jim.
0
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Thanks guy for the extra entertainment.

Ldufresne19
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.