title: Insert rows into Access db from C# using Microsoft.Jet.OLEDB.4.0, autonumber column is set to zero
body: <p>I'm using C# and Microsoft.Jet.OLEDB.4.0 provider to insert rows into an Access mdb.</p>
  
  <p>Yes, I know Access sucks.  It's a huge legacy app, and everything else works OK.</p>
  
  <p>The table has an autonumber column.  I insert the rows, but the autonumber column is set to zero.</p>
  
  <p>I Googled the question and read all the articles I could find on this subject.  One suggested inserting -1 for the autonumber column, but this didn't work.  None of the other suggestions I could find worked.</p>
  
  <p>I am using OleDbParameter's, not concatenating a big SQL text string.</p>
  
  <p>I've tried the insert with and without a transaction.  No difference.</p>
  
  <p>How do I get this insert to work (i.e. set the autonumber column contents correctly)?</p>
  
  <p>Thanks very much in advance,</p>
  
  <p>Adam Leffert</p>