title: Multiple instances of same access database are open on 1 machine - problem
body: <p>I'm having issues with a ms access 2007 accdb, using Windows Server 2008 task scheduler for scheduled tasks.  The problem is the file that's being opened by the task scheduler is opening/closing properly, but the 'lock' file (.laccdb) remains visible after the database is closed, which is an indicator that the access db thinks it's still open.  Each time a new task runs, a new instance of access is being opened.  I opened the Schema to show roster of all users in the database and it's showing 3 duplicates of the server name/Admin account.  Below is an example of the immediate window in access:</p>
  
  <p>COMPUTER_NAME    LOGIN_NAME    CONNECTED   SUSPECT_STATE
  SERVER           Admin         True        Null
  SERVER           Admin         True        Null
  SERVER           Admin         True        Null</p>
  
  <p>I'm hoping someone else has had this problem and knows 1) How to easily close all the open instances of access and 2) how to prevent this from occuring when running a task.  I have "Do not start a new instance" set under the task's 'settings' tab, but this is irrelevant b/c none of the tasks were running simultaneously.  Thanks in advance for any assistance.</p>