Enter Username and return Computer name

[elliotgr]

I have a list of usernames and wish to see what computers they are using on the lan.
How do I return the list of computer names?
From this I should be able to see who is running explorer.exe to get their username?
All the code I can find only works on my computer and not over the lan.

 

[Rx_]

Let me ask you a few questions since you have code that works on your computer. The trick may be to have an instance of Access running on each user's computer, harvest the details, and write the details to a shared database table. There are several ways to deploy an application so lets start with a few basics.

1. Is your Access database split for the Front-End (user interface) with the tables linked to a common database?

2. Where does each user open your Access Application and the Access.exe (executable). e.g. is MS Access installed on each users desktop? Is your Access application on each user's desktop or do you have everyone start it from a network location?

In the advance box click on the # button and post your code that reads the versions between the tags.
Do you have a Reference set in your code windows to Internet Explorer in your application.

This will at least give the community some ideas on suggestions.

 

[elliotgr]

Sorry, the users do not have MS Access on their PC's.
I am writing a program to harvest the computer name based on the username of people who are currently logged into the machine, based on a table of usernames in Access. The one thing I can guarantee is that explorer (Windows Explorer, not Internet Explorer) will be open on each PC. I can find the user of Windows Explorer.

 

[Rx_]

OK, if I understand this, the Acess table is just the lookup for user name / computer.

You are expecting users to be in Windows Explorer on their own workstation.
The process to get remote network users is not something I can help you with.

Are you saying that you can presently "find the user of Windows Explorer" from a user on your network?
Expand on that please.

From there you have a userID and are needing a lookup process for the userid to match in your Access table, there are several ways to accomplish that. I can help you with that. Do you have any code to post?