title: SQLite linked table in Access gives #Deleted values only after inserting a new value
body: <p>In MS Access (Office 365) I'm using the <a href="http://www.ch-werner.de/sqliteodbc/" rel="nofollow noreferrer">SQLite ODBC driver</a> (0.9996) to link to a table in an SQLite 3 database.</p>
  
  <p><strong>Problem</strong></p>
  
  <p>When I open the linked table it can display its contents, but after I insert a new entry to the table it displays <code>#Deleted</code> in every field of the new entry. Closing and re-opening the table will display the new entry correctly. How can I prevent this unusual behaviour, so that after new entries are inserted they display normally without needing to close and re-open the table?</p>
  
  <p><strong>Steps to reproduce</strong></p>
  
  <p>Create the following table in <code>example.sqlite</code>.</p>
  
  <pre class="lang-sql prettyprint-override"><code>create table example (
  id integer primary key,
  sample_type text
  );
  </code></pre>
  
  <p>Create a linked table using the SQLite ODBC driver and try to insert values into the "sample_type" column.</p>