title: Updating an SQLite database via an ODBC linked table in Access
body: <p>I am having an issue with an SQLite database.  I am using the SQLite ODBC from <a href="http://www.ch-werner.de/sqliteodbc/" rel="noreferrer">http://www.ch-werner.de/sqliteodbc/</a>  Installed the 64-bit version and created the ODBC with these settings:</p>
  
  <p><img src="https://i.stack.imgur.com/TEcXd.png" alt="enter image description here"></p>
  
  <p>I open my Access database and link to the datasource.  I can open the table, add records, but cannot delete or edit any records.  Is there something I need to fix on the ODBC side to allow this?  The error I get when I try to delete a record is: </p>
  
  <blockquote>
    <p>The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time.</p>
  </blockquote>
  
  <p>When I edit a record I get:</p>
  
  <blockquote>
    <p>The record has been changed by another user since you started editing it.  If you save the record, you will overwrite the changed the other user made.</p>
  </blockquote>
  
  <p>Save record is disabled.  Only copy to clipboard or drop changes is available.</p>