Check out this link to my similar question.
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/487011
JesseBalk's answer did it for me. I amended his/her code for my purposes. Copy this to a new module, I called mine GetUserInfo.
*****************************
Option Compare...
Thanks FancyPrairie, and JesseBalk.
The API calls solved two of my three problems. I now have the Username/UserID and the Machine Name. I am still lacking the Windows 2000 Server group memberships (which I want to use to grant particular users of my database access to appropriate functions...
Using Windows 2000:
1. See who's using the DB: Follow this trail on the computer hosting the database's data --> open Control Panel: Admin Tools: Computer Management: Shared Folders: Open Files, and check to see if your database's data file(s) are open. If they are, contact the user and ask...
Colleagues:
Using Access 2000, I need to capture the Windows 2000 userid (such as from whoami.exe) and group memberships in a form field and post it to a table when a record is edited.
How do I do this?
(I seem to remember this as a part of the concept of System Calls in Access 95, but can find...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.