title: Excel Data Connection Locks Access DB, Prevents Second Connection's Refresh
body: <p>I have two data connections to different queries in the same Access DB. The second one always fails (regardless of which I run first). </p>
  
  <p>When I look at the database, I notice that it has a lock file, which I think is causing the problem. It stays locked until I close the Excel file. <strong>Can anyone help me to unlock the db as soon as my import is complete?</strong></p>
  
  <hr>
  
  <p><strong>Additional info:</strong></p>
  
  <p>I'm using Excel and Access 2010.</p>
  
  <p>The error:</p>
  
  <blockquote>
    <p>"The text file specification '<em>MyQuery</em> Link Specification' does not exist. You cannot import, export, or link using the specification."</p>
  </blockquote>
  
  <p>Connection String (<em>note: I'm using Command type: Table</em>):</p>
  
  <pre><code>Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin
  ;Data Source=A:\folder\folder\My Database.accdb
  ;Mode=Share Deny None
  ;Extended Properties=""
  ;Jet OLEDB:System database=""
  ;Jet OLEDB:Registry Path=""
  ;Jet OLEDB:Engine Type=6
  ;Jet OLEDB:Database Locking Mode=0
  ;Jet OLEDB:Global Partial Bulk Ops=2
  ;Jet OLEDB:Global Bulk Transactions=1
  ;Jet OLEDB:New Database Password=""
  ;Jet OLEDB:Create System Database=False
  ;Jet OLEDB:Encrypt Database=False
  ;Jet OLEDB:Don't Copy Locale on Compact=False
  ;Jet OLEDB:Compact Without Replica Repair=False
  ;Jet OLEDB:SFP=False
  ;Jet OLEDB:Support Complex Data=False
  ;Jet OLEDB:Bypass UserInfo Validation=False
  </code></pre>
  
  <p>Lastly, based on <a href="https://stackoverflow.com/questions/3500072/excel-oledb-connection-to-ms-access-database-lock-access-db">this post</a>, I've tried changing my Mode from "Share Deny None" to "Read", but it didn't help. Nor do I understand why it would have, but I tried.</p>
  
  <p><strong>Edit:</strong> I've continued to research this issue, but cannot find a solution. I've since tried adding in an additional statement into my connection string, <code>ReadOnly = True</code> but no luck.</p>