title: Why is my Access database not up-to-date when I read it from another process?
body: <p>In my application I do the follwing things:</p>
  
  <ol>
  <li>Open a Access database (.mdb) using Jet/ADO and VB6</li>
  <li>Clear and re-fill a table with new data </li>
  <li>Close the database</li>
  <li>Start another process which does something with the new data.</li>
  </ol>
  
  <p>The problem is that <em>sometimes</em> the second process cannot find the new data. Sometimes the table is just empty, sometimes RecordCount > 0, but EOF is true and I cannot do a MoveFirst or MoveNext. In a nutshell: All kinds of weird things.</p>
  
  <p>My current workaround is adding a delay between closing the database and starting the second process.</p>
  
  <ul>
  <li>What is happening here?</li>
  <li>Can I do something about it? (Besides using a different database)</li>
  </ul>