If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Managing Database Users
I have a group db that is accessed by several users updating a main table via
a form. I need to be able to see who is in the database at any given time (for maintenance purposes). I know there are external applications avail to monitor this (for a small fee) but I was hoping Access could do this also. Having no luck finding that feature is it possible (without having to setup user/sercurity accounts). Any help is greatful. |
#2
|
|||
|
|||
Managing Database Users
Hi,
You might want to check out the LDBView utility from Microsoft: http://support.microsoft.com/kb/176670 Also, you can view open shared files by right-clicking on your "My Computer" and choosing "Manage". I presume the database is out on a network share. Choose "Action" menu and then "Connect to another computer ...". Enter the name of the network computer. Expand the "System Tools" item, then the "Shared Folders" item and then click on the "Open Files" item. This may require certain permissions for you on the network computer. Check with your network IT people if it does not work. Hope this helps, Clifford Bass "Ms SDB" wrote: I have a group db that is accessed by several users updating a main table via a form. I need to be able to see who is in the database at any given time (for maintenance purposes). I know there are external applications avail to monitor this (for a small fee) but I was hoping Access could do this also. Having no luck finding that feature is it possible (without having to setup user/sercurity accounts). Any help is greatful. |
#3
|
|||
|
|||
Managing Database Users
Hi,
Also see http://www.granite.ab.ca/access/corruption/workstation.htm for some other similar information. Clifford Bass "Ms SDB" wrote: I have a group db that is accessed by several users updating a main table via a form. I need to be able to see who is in the database at any given time (for maintenance purposes). I know there are external applications avail to monitor this (for a small fee) but I was hoping Access could do this also. Having no luck finding that feature is it possible (without having to setup user/sercurity accounts). Any help is greatful. |
#4
|
|||
|
|||
Managing Database Users
"Ms SDB" wrote in message
... I have a group db that is accessed by several users updating a main table via a form. I need to be able to see who is in the database at any given time (for maintenance purposes). I know there are external applications avail to monitor this (for a small fee) but I was hoping Access could do this also. Having no luck finding that feature is it possible (without having to setup user/sercurity accounts). Any help is greatful. You can maintain a log of users in a table easily enough with a bit of code in the form's Open event. You can grab the user's Windows name using the code he http://www.mvps.org/access/api/api0008.htm and computer name: http://www.mvps.org/access/api/api0009.htm HTH - Keith. www.keithwilby.co.uk |
Thread Tools | |
Display Modes | |
|
|