title: SQLite and Multiple Users
body: <p>I have a C# Winforms application.  Part of the application pulls the contents of a SQLite table and displays it to the screen on a datagridview.  I seem to have a problem where multiple users/computers are using the application.</p>
  
  <p>When the program loads, it opens a single connection to the SQLite DB engine, which remains open until the user exits the program.  On load, it refreshes the table in question and continues to do so at regular intervals.  The table correctly updates when one user is using it or if that one user has more than one instance of the program open.  If, however, more than one person uses it, the table doesn't seem to reflect changes made by other users until the program is closed and reopened.</p>
  
  <p>An example - the first user (user A) logs in.  the table has 5 entries.  they add one to it.  there are now 6 entries.  User B now logs in and sees 6 entries.  User A enters another record, for a total of 7.  User B sees 6 even after the automatic refresh.  And won't see 7 until they close out and reopen the program.  User A sees 7 without any issue.</p>
  
  <p>Any idea what could be causing this problem?  It has to be something related to the DB engine for SQLite as I'm 100% sure my auto refresh is working properly.  I suspect it has something to do with the write-ahead-logging feature or the connection pooling (which I have enabled).  I disabled both to see what would happen, and the same issue occurs.</p>