Who's using the network...?

okay, so i have a network and i want to know how to go about finding out who is logged in and what they are doing. that is to say what databases they are accessing and stuff like that. any pointers or general directions would be very useful.

finding out what databases are being used is the most important really. i know it can be done because access tells me who is using a particular database when i want to modify it. but it only tells me the first it encounters. so i can get them out of the database but then there is usually more than one person accessing it.

[Edited by Jamagei on 08-22-2000 at 06:39 AM]

i actually did the same thing for my client
and still working on improving it
(works fabilious)

make a table called USERS (to hold users)
make a global vriable called UserName
make another table called LoggedUsers
teach time a database/table is opened
get the username thats logged in
write it to the LOGGEDUSER table..
and read that table when checking

works GREAT
you got to do a lot of error checking
and make sure the user loggs off properly
ect...

how do i know when a table is opened though? does each computer need to have this program running in the background? or does it go on the server or what?

i am confused. i can see how that works but i don't know how to find out which ser is online or whether they are using a program that is accessing a database.

In each client version, when the client logs on,have it send its name to the other computer whch puts it in the table...