https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/70022.aspxMon, 05 Sep 2011 17:26:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70022Patrick Halstead0https://www.infopathdev.com:443/forums/thread/70022.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=70022<p>Hi JohnT and welcome,</p><p>Believe it or not, you have discovered some of the limitations inherent in InfoPath&#39;s out-of-box support for databases. Those &quot;gaps&quot; were the main reason we developed a generic Web Service back in 2004 for connecting to SQL. It&#39;s called DBXL and will allow you to add fields easily and roundtrip data types with full fidelity (since it also stores the XML in SQL). It doesn&#39;t work with Access. You can download a free trial from our Qdabra dot com web site under products. It&#39;s inexpensive and will save you tremendous amount of time integrating your forms with SQL. Plus it has many other benefits.</p><p>Cheers!</p>https://www.infopathdev.com:443/forums/thread/69854.aspxTue, 30 Aug 2011 20:57:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69854JohnT0https://www.infopathdev.com:443/forums/thread/69854.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=69854<p>Hello All!</p> <p>&nbsp;I&#39;m new and have a few questions that should have simple answers...yet I&#39;m having a hard time finding answers.&nbsp; Would appreciate your help!</p> <p>&nbsp;Question 1: I am trying to use an IP form as a data entry form.&nbsp; I want to data to be stored in an MS SQL Server 2008 database (possibly an Access 2010 db temporarily).&nbsp; The data entered on one form makes up one record and will have approx 400 fields.&nbsp; There should be a straightforward way to do this in IP (I would think), but I cannot find it. It seems to be easier to display data than to add it.</p> <p>Question 2: I made an attempt to hook up an Access database, but when I tried to map the fields on a form to their corresponsiding fields in the data, I got an error message about binding a non-repeating control to a repeating field or group.&nbsp; Nothing in my form should repeat. Every record has different data. What am I doing wrong?</p> <p>Question 3: What data types in SQL Server and MS Access correspond to which data types in IP?&nbsp; For example, what should I use as the data type for a check box? Yes/No?&nbsp; When I choose that type, it gives me an error if I try to submit data.</p> <p>Thanks in advance for tolerating these stupid questions.&nbsp; I SHOULD be able to find it in MS help...but then again, you all know MS help ;-)</p>