Retrieve Logged in user ID with VBA

[jeremie_ingram]

I am currently developing a system that will be used by MANY depts. and individuals within one agency. What I would like to do is 1 of 2 things.
1. Use the NT domain server (PDC) as a reference for credentials. I would retrieve the logged in users ID from the workstation, then prompt them fro their password (referenced to the PDC). This would eliminate the need for multiple log ins and would reduce the amt of password required by individuals. Sounds nice, but most likely too complicated to deal with since the development is a bit rushed.

2. This new MDB will include tools for HR to track all employees. Their tables would include the information I could use to cross reference against the user ID that is logged into the workstation. In other words, I could easily write the script to compare the ID retrieved from the system VS that of HR, as well as determine what restrictions/menu items these individuals should see.

So what I need help with is, how can I retrieve the user ID from the workstation.

Any thoughts/suggestions on this would be appreciated.

Thanks.

 

[Mile-O]

Have a look at this thread.