Managing Database Users

[Ms SDB]

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.

 

[Clifford Bass]

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

 

[Clifford Bass]

Hi,

Also see <http://www.granite.ab.ca/access/corruption/workstation.htm>
for some other similar information.

Clifford Bass

 

[Keith Wilby]

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 here:

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