List all current users of database

[AllyBally]

I am sure that I have seen a module which will return the login ids of all users who are in a database. I have seen one which will return the computer machine number which is not really much help unless you have a list of all machine numbers and a telephone that is nearby. What I need is to show the id used by a user to log in to their desktop machine.

Any ideas?

Alain

 

[SydneyGeek]

Hi Alain,

There are a few ways to do this but not all of the simple ones are good, and not all of the good ones are simple...

If you are using Workgroup Security, the Access User Roster will provide you with what you need -- Link.

Otherwise, get hold of The Access Workbench, a utility produced by Garry Robinson. This guy really knows Access security -- he wrote a book on it (Real World Microsoft Access Database Protection and Security). There is heaps in the book that you will likely find useful, including a whole chapter on user and object surveillance.

Denis

 

[AllyBally]

Thanks Sydney, I will check out the "Workbench". The problem is always an issue when maintenance needs to done on an access back end and you aks evryone to log out but there is always on user left and as we have multiple offices........

Thanks,

Alain

 

[MyBoo]

Thanks Sydney, I will check out the "Workbench". The problem is always an issue when maintenance needs to done on an access back end and you aks evryone to log out but there is always on user left and as we have multiple offices........

Thanks,

Alain

Type out the databasename.ldb file
This file is created everytime a database is opened and contains the userID of every user connected/using that database currently. It's not fool proof but if all you're looking for is a quick way to identify who is still logged on, this may help. Once the last user exits the application, this .ldb file will disappear.

 

[AllyBally]

MyBoo,
Right clicking on the ldb file and selecting properties used to give the LogonID of the user and I used this, albeit it was not always right, before we moved to Access 2003. Now it no longer shows that info and why I am looking for preferably a bolt on module that I can use.

All I have at the moment is the irritation of the sight of the ldb file without the knowledge of who.grrrrrrrrrrrrrr

 

[MyBoo]

MyBoo,
Right clicking on the ldb file and selecting properties used to give the LogonID of the user and I used this, albeit it was not always right, before we moved to Access 2003. Now it no longer shows that info and why I am looking for preferably a bolt on module that I can use.

All I have at the moment is the irritation of the sight of the ldb file without the knowledge of who.grrrrrrrrrrrrrr

Well, all I can tell you is that the format of the .ldb file seems the same in 2003/2002/2000 and it lists every user connected to the database. If you OPEN the .ldb file in notepad, you should see the computername of each device attached to that Access application along with the userID they used to connect to the application. If you do NOT use any form of Security to attach to MS Access, then all the userIDs will be listed as Admin.

I don't think there's a module out there that can translate Admin into a user's actual ID. Without some sort of logon (security) procedure, it doesn't get passed from the remote connection so there's nothing to translate or record beyond "Admin".

In my corporate environment, the computername is the phone# of the user.... not fool proof, but it gives you something.

 

[AllyBally]

MyBoo
Many thanks. I had misunderstood what you meant. Used Notepad at is shows me the ID of the PC. We have a database of PC IDs with contact name and number.

Sorted........

Alain

 

[MyBoo]

MyBoo
Many thanks. I had misunderstood what you meant. Used Notepad at is shows me the ID of the PC. We have a database of PC IDs with contact name and number.

Sorted........

Alain

ah! Seems I'm dating myself by referencing the TYPE command.
Glad we straightened things out and you now have a solution.