title: msaccess laccdb lock file on network share
body: <p>I have a simple access database file that works perfectly fine on a local drive in a local folder.  If I share that exact same folder, then map that folder on the same computer, the laccdb lock file isn't cleared when I close the database.</p>
  <p>The database itself doesn't seem to matter.  I created a new database with just one table and the same problem occurs:</p>
  <ol>
  <li>create new access database on C:\localfolder</li>
  <li>access works fine.  close access, the laccdb file deletes</li>
  <li>create a share of c:\localfolder, then map Z:\ to \computername\localfolder</li>
  <li>open access database, close access database.  laccdb lock file does not delete</li>
  </ol>
  <p>the share settings are correct.  &quot;everyone&quot; has read/write</p>
  <p>additional info:  if I go to a different computer and map a drive to that &quot;bad&quot; computer I can open the access database fine, and the lock file correctly disappears when I close it.  If I go back to the &quot;bad&quot; computer and map a drive to the &quot;good&quot; computer and open an access database then close it, the lock file doesn't delete.</p>
  <p>Also on a good computer I can open the lock file in notepad and see info on who has it locked (me), but on the &quot;bad&quot; computer, it creates the lock file but it doesn't write any data to it... almost like it <em>thinks</em> it doesn't have write access to the file, or delete access... but it does.  it absolutely does. as soon as access closes, I can open explorer and delete the file myself.</p>
  <p>I seriously as a loss.  This machine has worked perfectly fine with access database lock files for 4 years.  Suddenly today it won't work anymore.  No updates have been installed and there's nothing to roll back to in a restore.</p>