show current logged users
-
Can anyone tell me how to get information on who is currently working
in my database? I have up to 20 users who work in the same database.
Any help would be appreciated.
-
In Enterprise Manager you can view it in Management -> Current Activity -> Process Info. Or use the sp_who procedure.
-
thanks!
-
Not really an Access question was it then ?
If you have a view on sysprocesses you can do it by linking to the view. Or as an Access project a report based on the same view
(Assuming you are looking at a SQL Server database.)
DB
The systems fine with no users loggged in. Can we keep it that way ?br> -
Also for Access databases (mdb's) and outside of anything in EM, I used to just read the Access .ldb file with Notepad and that would list all the workstation names that were connected to my mdb file. The ldb is the temporary locking file that gets created when users were in the main mdb.
Sounds like you're all set though..
-
thank you all.
-
ok i think that was an easy one but I have another question: When we have an Access DB (not project) how can we forcefully disconnect the users that are connected to it? I don't think that you can though...
-
Have a look at this article:
Auto Logout Users for DB Maintenance
http://www.databasejournal.com/features/msaccess/article.php/3548586
Phillip L. Hagan -
yeap! I have already implemented something like that so that users actually log out with out leaving their PCs connectedto the Access DB all night long...
I guess that common problems usually lead to common solutions!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply