Controlling User Logons

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I have a 2-pronged question for an Access 2000 multiuser
environment: 1) How do I find out every user Access
thinks is logged on? 2) Can I/How do I force a user or
all users to log off?
Here's a case: I have 8 - 10 users logged on and I need
to make a change to a table in the database. Users say
they are out of Access, but Access still tells me someone
has open a query or form bound to the table. Or someone
has the table open. I want to find out what userid Access
thinks has the table open or even is logged on to the
database. And I want to force that user off. The same
issue applies to running a repair and compact. Any help
you can give me will be much appreciated.
 
Use a hidden True/False setting in a table.
Put a timer on the form to check this T/F setting.
If True then give a popup that you close the database remotely with a time counting.
Saveall, application.Quit

Pieter (NL)
 
LDBView.exe is a tool available at microsoft and wich let's you see every one connected to the database
Other way. From the computer that shares the (if you are using w2k or Xp database, under control panel>admin tools>computer managment>shared folders>sessions; you can terminate any session to your computer

Hope I helped
 
Back
Top