How can I find out who is in the Database?

[Dave]

Users must login using Access security
potentially 20 + users but in reality one 2 or 3 in at a time
DB NOT split

Problem is I sometimes come in early to do a little development and I can't
access anything because someone has forgot to close the DB the night before.
I have to go to every users machine, log in to their machine (or change
their windows password) and see if they had the DB open.
Sometimes I just feel like to a hard shutdown on all the users but.... well
that is another story.

NEWay: Is there someway I can "easily" find out who is in the DB and only
have to deal with going to their machine.
Does not need to be anything fancy.

Yes, I know - there are clearly multiple other issues here that I should be
considering but for now - I just want to know who is in the DB.

Any help here will be appreciated.

Thanks in advance

Dave

 

[Bob Barrows]

Users must login using Access security
potentially 20 + users but in reality one 2 or 3 in at a time
DB NOT split

Problem is I sometimes come in early to do a little development and I
can't access anything because someone has forgot to close the DB the
night before. I have to go to every users machine, log in to their
machine (or change their windows password) and see if they had the DB
open. Sometimes I just feel like to a hard shutdown on all the users
but.... well that is another story.

NEWay: Is there someway I can "easily" find out who is in the DB and
only have to deal with going to their machine.
Does not need to be anything fancy.

Yes, I know - there are clearly multiple other issues here that I
should be considering but for now - I just want to know who is in the
DB.

Multi-user activity is controlled by the .ldb file. You can look at it in
notepad to find the user(s). Or you can google for something called an
ldbviewer (I think) that I used to hear about.

 

[Dave]

Wow! That was about as easy as you can get.

Thanks much