More on Users in a Database (1 Viewer)

[Vassago]

http://support.microsoft.com/defaul...kb;en-us;176670

I downloaded this file and it works wonderfully in telling you how many users and what the computer names are that are logged into a database. Is there a way to tell the NT login of the person as well? You would think so, considering you can find this much out.

If anyone has a solution, please let me know.

Vassago

 

[Ramrod]

I have not used this, but ran across it a while back. See if this is what you are looking for...

http://www.mvps.org/access/api/api0008.htm

 

[Vassago]

Thanks for responding, however....

This will tell you YOU'RE username. What I need is the NT Login for all of the users ina database, not just the one you are signed in as.

If anyone else has a solution, please let me know.

Thanks,

Vassago

 

[jeff_i]

Try This

Vassago


I found this in another thread a couple of monthes ago, it does give you both machine name and the username

Hopefully it will work for what you need

 

[Vassago]

I'm using Access 97, was this made in a later version. I recieved the "Not a database file" error. If so, could you convert it for me if you have the time and it's not too much trouble.

Thanks,

Vassago

 

[jeff_i]

Try This

I converted it to 97 but I dont have any real way to test it, I opened it and said no when it asked me to convert and it worked so I can only hope it will work for you

Jeff

 

[chewy]

it wouldnt let me open the form. Could you post teh code?

 

[jeff_i]

Here is the Code

You might try searching for appuser I am sure I found it through this forum. Here is a copy of the code:



The database only has one form called frmldbviewer

Hope this helps