Missing Data Using MS Access
<p>I have a c# programm that uses MS Access. I execute the following SQL statement</p>

<pre><code>SELECT * FROM DATA LEFT JOIN LINEITEMS ON DATA.PRI_KEY=LINEITEMS.ID
</code></pre>

<p>Data.Pri_key is always populated as is Lineitems.ID.</p>

<p>I have a very large data file that populates the two tables Data &amp; Lineitems. This is invoice information which is printed out to a PDF using iTextSharp.</p>

<p>Intermittently through out the file some of the line item data for an invoice goes "missing" i.e. it never gets printed. </p>

<p>I have taken one of the invoices that exhibits the problem and have put its data in an input file on its own i.e. it produces one invoice. All the line items are printed from this file. Nothing goes missing.</p>

<p>Does anyone have any ideas? Is this an MS Access bug? If it is that would be a problem because Access is all that the client has.</p>
