Active User List

Scottie31

Registered User.
Local time
Today, 19:50
Joined
Jan 11, 2006
Messages
30
I'm new to working with databases and now I have 2 which I have to manage. There are probably anywhere from 10 to 30 people using these databases at any time and I would like to have a list of the active users. What's the easiest way to create a report of the active users?
 
You can write to a file when a user enter the application
 
If you are using access the ldb file will tell you who is currently active.
 
ldb file is not very helpful. If a user leaves the application and another still in,
the first stays in the ldb untill everyone get out.
If you want to know who is in the app now then write to a file when enter and when out
or
white to a table when in and remove when out.
 
Thanks....I looked at the ldb file and it just gives a computer ID by the looks of it and I have no idea who that would refer to. I'll most likely have to look at writting to a table as mentioned.
 
The only problem with either of these is that if your network goes ga-ga then you will have no clue as to who is in the DB right now.

What I did was have a switchboard form that wrote an entry in a "visits" table when you loaded the form. Since it was a startup form, you had no choice BUT to load it.

If you were admin or user, didn't matter. The form never went away. If you hit my switchboard's "close" button, you didn't close it, you just minimized and hid it. Then, when you exited, the form-exit event allowed me to write another "leaveing" record to the visits table.

I also had some automation such that if you tried to get in and the DB saw "entering" but no "leaving" - it synthesized a marker in that table that said, in effect, "must have missed the 'leaving' event."
 
Hi,

I have something similar in a db. i placed a boolean field in my table for each user. when they login, the boolean is updated to true until they logout where it is updated again to false.

when the db closes, it clears ALL boxes and again on open just incase it crashed so i get a clean slate when it opens.

regs,

Nigel
 

Users who are viewing this thread

Back
Top Bottom