Solved

Determine users in database: PC ID and LDBVIEW

Posted on 2001-08-21
6
1,014 Views
Last Modified: 2012-08-13
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
Comment
Question by:mjoyce
6 Comments
 
LVL 14

Accepted Solution

by:
mgrattan earned 80 total points
Comment Utility
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
 
LVL 6

Expert Comment

by:devtha
Comment Utility
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
 
LVL 6

Expert Comment

by:devtha
Comment Utility
I also use ldbview.exe to get the machine numbers first
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 54

Expert Comment

by:nico5038
Comment Utility
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
 

Author Comment

by:mjoyce
Comment Utility
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
 
LVL 14

Expert Comment

by:mgrattan
Comment Utility
Thanks for the follow-up.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now