title: Force all users to disconnect from 2010 Access backend database
body: <p>We have multi user frontend/backend MS Access 2010 application.  We added a process that will close remote frontends when we want to do work on backend such as compact and repair.  This is timer based check on table field that if has certain value will close the application.</p>
  
  <p>I do two checks to see if users are connected to database:</p>
  
  <ul>
  <li><p>i have login/logout process and can see who is still logged in (its form based so is fallible eg they close form but frontend is still open).</p></li>
  <li><p>i used .ldb file viewer to see if anything is still connected</p></li>
  </ul>
  
  <p>Two questions:</p>
  
  <ul>
  <li><p>is there any possibility that a connection to backed could exist if it wasn't viewable with ldb viewer?</p></li>
  <li><p>is there any bullet proof 100% certain way to forcefully disconnect all connections from backend?</p></li>
  </ul>