https://www.infopathdev.com:443/forums/141.aspxQdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/48300.aspxWed, 28 Oct 2009 00:37:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:48300Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/48300.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=48300<p>Hi:</p> <p>As far as I know, the first scenario you described should work -- at least I&#39;ve done that with SQL in the past and haven&#39;t had any troubles. I&#39;m not sure if the sample db described in <a href="http://office.microsoft.com/en-us/help/HA011199501033.aspx">this article</a> has an auto incrementing id, but I&#39;d imagine it would....</p>https://www.infopathdev.com:443/forums/thread/48113.aspxWed, 21 Oct 2009 18:04:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:48113jraylor0https://www.infopathdev.com:443/forums/thread/48113.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=48113<p>I have a Db with 6 fields. One of the fields is the primary key that auto increments, I have the InfoPath form connected to the DB. I am trying to do the following:</p> <p>When an end user opens the form, I want them to fill out the 5 text boxes and&nbsp;click submit button. When the submit button is clicked, I would like the data to go to the corresponding fields.&nbsp; When I test this, I get the following error:&nbsp; Infopath cannot submit the form.&nbsp; The form does not contain any new data to submit to the data source.</p> <p>I set up a second data source without the auto increment field and the data submitted without error.&nbsp; </p> <p>So I guess my question is:&nbsp; How do I force the primary key field in the access database to auto generate when the form is submitted?&nbsp; </p>