Solved

Determine users in database: PC ID and LDBVIEW

Posted on 2001-08-21
6
1,040 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
ID: 6410719
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
ID: 6410768
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
ID: 6410773
I also use ldbview.exe to get the machine numbers first
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 54

Expert Comment

by:nico5038
ID: 6990384
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
ID: 6993795
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
ID: 6994205
Thanks for the follow-up.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

816 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

9 Experts available now in Live!

Get 1:1 Help Now