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?
Active User List
- Thread starter Scottie31
- Start date
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.
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.
- Local time
- , 20:06
- Joined
- Feb 28, 2001
- Messages
- 28,588
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."
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."
NigelShaw
Registered User.
- Local time
- Today, 01:06
- Joined
- Jan 11, 2008
- Messages
- 1,575
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
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
