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/103595.aspxWed, 12 Aug 2015 18:31:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103595Marleah0https://www.infopathdev.com:443/forums/thread/103595.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=103595Hi, I have an infopath form that needs to submit information to an Access DB, I am having a problem as I need a unique id associated with the form to update ID fields that are primary keys in several tables, the fields were once auto increment primary key fields. How can I keep the autoincrement primary key feature of the Access tables, and have the infopath form update the field properly. My first attempt was to create a regular integer field for the primary key and attempt to get the max id field from the Access Table and increment by 1 when I submit the form. But I have not been successful trying to do this. Is there a way to keep the auto-increment primary key field and have it increment when the infopath form is submitted to the database. In some of the material I have encountered there is reference to doing just this type of thing. Specifically: Developing Solutions with Microsoft® InfoPath Chapter 6, Database Integration. But on the Microsoft Office Dev site, it states that Infopath does not support the auto-increment datatype in Access. Please help. Thanks, Marleah Isom