How can I tell who has the database open?

  • Thread starter Thread starter shelley
  • Start date Start date
S

shelley

I want to go in and do som edesign changes, but there are staff with the
database open. How can I tell who is in the database and can I kick them out?
 
What sort of design changes? It sounds as though you may not have split your
application into a front-end (containing the queries, forms, reports, macros
and modules), linked to a back-end (containing the tables and relations).
Only the back-end should be on the server: each user should have his/her own
copy of the front-end, ideally on his/her hard drive. In that way, you can
make changes to your heart's content in your front-end, and distribute a new
copy of the front-end to everyone else once you're satisfied with the
changes.
 
TheScullster said:
Not sure about the kicking out bit, but look for LDBView.exe. This
provides a list of current users for Access database.
Click to expand...

LDBView.exe is really intended for Access 97 and earlier, although I believe
it does work on newer versions. See http://support.microsoft.com/kb/176670
for details. Note, though, that unless you've applied Access User-Level
Security (so that it's necessary to log into Access to use the application),
all it will show is Admin for each user (it shows the Access UserID, not the
network one). It will show the computer name of the users though.

For Jet 4.0 (Access 2000, 2002 and 2003), you can use UserRoster. See
http://support.microsoft.com/kb/198755/EN-US/

AFAIK, UserRoster works in Access 2007 as well, but you'd need to specify a
different connection string if you're using an ACCDB.

UserRoster has the same limitation as LDBView.exe, though: it doesn't show
network ID, so it's often difficult to relate what's returned to specific
users.
 
Another problem with ldbview is that is shows everyone who has logged in
since the mdb was first opened. So user 1 could log in, user 2 log in, user
1 log out, and it shows both users as logged it. I don't know about
userroster
 
Back
Top