Tracking Users

[Jared]

Do you know how to track users that are currently using a
secured database? I have created a database that many
different people use at the same time. If I need to make a
change or add a new object I need exclusive access. I need
to know if there is a way for me to track what users are
in the database. Also if at all possible I would like to
know what the users are doing inside the database but most
importantly, who I is the database.

 

[Chris Kennedy]

Hi Jared,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
"..I need to know if there is a way for me to track what users are in the
database. Also if at all possible I would like to know what the users are
doing inside the database but most importantly, who I is the database."

You can use Jet UserRoster to see who's in the database, see:HOW TO: Check
Who Logged into Database with Jet UserRoster in Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;198755

As to what they are doing??? that would be a great tool

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[DanK]

One solution:

Make sure the database is NOT on the server but a client
station that is shared. Then, all you have to do is shut
down and restart without being connected to the network.
You'll definately be exclusive then!

I think knowing who is doing what is a network thing. I
understand your question, but I don't have the answer
you're looking for. Sorry.

One possible approach is to have variables that are
populated with the name of the person "logging" into your
Access application, then when they "Log" off, the variable
is cleared. Then, at any time, you can go in and call up
the values of all the variable and the ones with a name
will tell you who is on it at that moment. Realize,
however, that by the time you react to the information, it
could change... from second to second.