Insert rows into Access db from C# using Microsoft.Jet.OLEDB.4.0, autonumber column is set to zero
I'm using C# and Microsoft.Jet.OLEDB.4.0 provider to insert rows into an Access mdb. Yes, I know Access sucks. It's a huge legacy app, and everything else works OK. The table has an autonumber column. I insert the rows, but the autonumber column is set to zero. I Googled the question and read all the articles I could find on this su...