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/48583.aspxTue, 03 Nov 2009 21:31:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:48583Bizif0https://www.infopathdev.com:443/forums/thread/48583.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=48583<p>I hate to necro this month old thread, but is it possible to work around the 255 text limit in access when connecting a form to the database?</p>https://www.infopathdev.com:443/forums/thread/47284.aspxWed, 23 Sep 2009 17:13:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:47284chris.sprague0https://www.infopathdev.com:443/forums/thread/47284.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=47284Sometimes you just need to talk it out... there was a &quot;Memo&quot; field that I overlooked... Text seems to be fine.https://www.infopathdev.com:443/forums/thread/47283.aspxWed, 23 Sep 2009 17:04:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:47283chris.sprague0https://www.infopathdev.com:443/forums/thread/47283.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=47283Hi All -- Been trying to figure this out for a few days now to no avail... I have an existing Access 2003 database that I&#39;m trying to create an InfoPath 2003 front end for (more of a data entry form). I created the form form the &quot;New From Data Connection&quot; but noticed when going through the Wizard that Submit is disabled because the database contains Long Data Types (Text, etc). Did some googling, came across a tutorial on the MS site that links the Northwind example DB to InfoPath, followed it step by step (several times) with the same &#39;Submit&#39; error -- although, according to the tutorial there shouldn&#39;t be any problems. Now the Northwind DB is full of Long Data Types. So I guess my question is... Text and Memo fields are not by any means obscure when coming across Access databases - is there even an alternative for these field types? Is there anyway around the lack of Long Data Type support, maybe with some custom code? I should also note that I have no problem retrieving data from the db... Any thoughts or suggestions would be greatly appreciated!!! THanks, Chris