how to retrieve network name
Posted on 2014-02-12
i have constantly people posing a lock on a file on the network, without me knowing who this user is, when i go to the server under computer/manage/shared folder/open files/, i get the network names, however i still don't know who they are..
the same is when i want to look up at sql server/activity monitor, to see which user is running a statement that is blocking other transactions, there is a column host that shows me a user name, but the same issue as above...
therefore, since we use an access db linked to sql, and each user must enter their initial, before opening any form on the app, i would like to have a function that retrieves both, the network name as well as the host name displayed in sql monitor, and would save them in the initials table.