title: OleDbDataAdapter Sporadic Missing Records
body: <p>In my application I'm getting some data out of a local MS Access database file.  I'm puzzled by a sporadic issue where my query for all records of a specific table sometimes returns all the records, and sometimes returns all but the last record.  I'm using the following code</p>
  
  <pre><code>string resourceConStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data source = C:/FileName.mdb";
  OleDbConnection resourceCon = new OleDbConnection(resourceConStr);
  OleDbDataAdapter personnelAdapter = new OleDbDataAdapter("Select * From Personnel", resourceCon);
  DataTable personnel = new DataTable();
  personnelAdapter.Fill(personnel);
  </code></pre>
  
  <p>When I look at the <code>personnel</code> DataTable, sometimes I have the correct # of records and sometimes I'm missing the last record from the Access table.  I haven't been able to find any pattern as to when it works successfully and when it does not.  Any idea what could be the reason for this or suggestions or a way to validate that all records were copied into the DataTable sucessfully?  Thanks</p>