Using VBA to Generate a User List

[dleiba]

Hey guys,

Is it possible to use VBA to generate a list of ALL users presently logged into the database and display this list on a form?

Please let me know.

Thanks

Dominic

 

[MichaelRed]

Welllllllllll,

It depends on the network and the database. If either have sufficient security to require useranme/password security, then usernames are available -at leasat to theose who have read permisison to that part of the system.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[nickjar2]

If your database is secure try this:

http://support.microsoft.com/suppor...d on&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

I use it all the time. You may have to tweak it (I did) but it works really well.

Nick

 

[Databaseguy]

Download Jetutils.exe from MS. There's a couple of functions there that read the *.LDB file. It even comes with a form.... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[MichaelRed]

I am not familiar with the article from the MS site. They generally reference the .LDB file, like Databaseguy. The .LDB file is really a record locking file, and is maintained through the Ms Access programm. It is not an absoloute indicator ow who is or even has been 'into' the db. It does have a record of all 'current' users, however it may (and often does) also have a record of 'previous' users as well. IF you use this route, you need to carefully read the literature re the file use to understand the role it plays -so you will NOT be confused by the inconsistiency int he list and actual users.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[dleiba]

Thanks guys!

The Jetutils.exe file was a BIG help.

works like a charm

Later

Dominic