Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1132
  • Last Modified:

Determine users in database: PC ID and LDBVIEW

Hello,

I occasionally have to boot all the users out of a database. I use the LDBView utility to see if anyone is in a file, then kick them all out.
The problem is that this file gives the PC name, not the user name. I use an MDW workgroup to identify the users in the DB.
How can I get a list of all the User Names as used in LDBView and their corresponding network logins or MDW logins?
Thanks,
Michael
0
mjoyce
Asked:
mjoyce
1 Solution
 
mgrattanCommented:
The following link is for a free ActiveX component (with source code) that gives you the following information about a user's computer:

 LoginName
 WorkstationName
 IPAddress
 HostName
 MACAddress (Ethernet Card Address)

http://www.appliedolap.com/Products/NetInfo/default.htm

You can use this control and/or the source code to cross-check the WorkStationName against the Machine Name listed in the LDBViewer and, additionally, compare the LoginName to the CurrentUser function's results in Access.  

Does that help?
0
 
devthaCommented:
what I do is use the following command on the DOS prompt
nbtstat -a machinenumber
then send message using
NET SEND machinenumber message

Based upon this I have a small access app that does this for me depending on the users selected (Alist maintained for all users of app. whose machine numbers I know.
0
 
devthaCommented:
I also use ldbview.exe to get the machine numbers first
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
nico5038Commented:
for mjoyce

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question is:
 - Answered by: mgrattan  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
mjoyceAuthor Commented:
Haven't tried it, since installing new ActiveX components wasn't allowed with the network rights. ended up solving the problem by having all users log in with a workgroup file.
0
 
mgrattanCommented:
Thanks for the follow-up.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now