Unanswered: Can you see which users are logged into a DBase?
I designed a database in MS Access 2000 that has user-level security passwords. I would like to be able to see which users are in the database at any given time (if I need to kick them out to do updates).
Is this possible? If so, please explain in detailed steps since I am not very experienced.
Exlpaining it would be a little hard by itself so I'm attaching a sample database....
basically I set up a table that keeps track of users & whether they're logged in or not.
Next I created a form that sets their status. (This form is hidden so the process is transparent to the user)
Next I went to "Tools -> Startup" & set that form to be the starting form for the database
I also created a form where you can view all of the users & their status.
When the database is closed their status gets reset.
To use this in your own db just copy the 2 forms the 1 table & set your db to start with the "frmStartup" form