Show other users who is currently logged on

[steveatdb]

Hi I have a split database, on the first page the user "logs in" where their
name is entered and a log in entry is stored. I was wondering if anyone knew
of a way to display on the main page how many people are logged in at one
time and who they are. Either using the log in feature or something eles
entirely.
Any help would be greatly appreciated.
Thanks
Oh and its Access 2000
-Steve

 

[pietlinden]

Hi I have a split database, on the first page the user "logs in" where their
name is entered and a log in entry is stored. I was wondering if anyone knew
of a way to display on the main page how many people are logged in at one
time and who they are. Either using the log in feature or something eles
entirely.
Any help would be greatly appreciated.
Thanks
Oh and its Access 2000
-Steve

like this?
http://www.mvps.org/access/general/gen0034.htm

 

[steveatdb]

Sort of, but a bit different.
I think I can make something work if I knew how to make a table where by it
adds an exit time when a users leaves the database this would be helpful for
other reasons as well currently I have a table which keep a record of what
users log in to the database however it doesnt show if or when they logged
out. Anyway if anyone knows how to add a feild that shows the exit time that
gets updated when a user closes the database that would be wonderful.

 

[Chris W]

if you have a table of users held on the central DB you could perhaps do the
following:

1. Add a new column to hold the date/time exited
2. On logon, check the table for existence of user, and if found, set
date/time logged out to null and update date/time logged on to the date/time
they logged on, otherwise insert a new row for that user
3. On logging out - update the date/time logged out

Then for your query of who is currently in, just query the table where
date/time logged out is null

HTH