If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I find out who is in the Database?
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 |
#2
|
|||
|
|||
How can I find out who is in the Database?
Dave wrote:
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. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
#3
|
|||
|
|||
How can I find out who is in the Database?
Wow! That was about as easy as you can get.
Thanks much "Bob Barrows" wrote in message ... Dave wrote: 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. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
Thread Tools | |
Display Modes | |
|
|