InfoPath Dev

 I have created a infopath form which will submit to a Access Database.  One of the controls in my form is a text field that has a text limit of 255 characters.  Because of this limitation, I am going to have to save this control on a sharepoint.  Does anyone know how I can save one data control to a sharepoint while the rest of the data controls submit to a access database?

You could do this by making the two controls you want to publish on sharepoint your property promotions (in the form options). For the rest, you'll have to use custom code.