Please help!! Trying to Submit form to Access Database to no avail

[Bob]

Hi, I am hoping that someone will be able to help as I have exhausted all
other avenues. I have an Access 2007 Database that I created which includes
multiple tables/fields which coincide with an IT Consultants documentation of
work performed and evironment. I then created an InfoPath2007 Form, tied it
to the Access database as a Main connection, Bound my InfoPath Text boxes to
the related fields in the Database (So I thought I did). I then Published
the Form to a Sharepoint site. I am then able to access the form via
Sharepoint, fill it out and save it to the Doc. Library, however I am unable
to Submit the Data to the Database. While in the Data Connection Wizard, I
see the following error which could very well be the problem..if so Why am I
getting it and what can I do to address it?
Error: Submit Status not allowed - One or more of the columns in the data
source has a large binary data type such as text, ntext, hyperlink, or image.
Large binary datatypes are not supported.
If this is the problem what can i use for Data types of fields that will
contain names, phone mumbers, addresses, general text...etc???
THANK YOU ALL in advance for your assistance!!!!
Bob

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello
You have to start designing the Infopath form with the dataconnetion and not
adding it after designing through Add dataconnections
Else you have to use Webservice to submit the data to the DB

 

[Aly Esparza]

I have my database and I have created a form based on a database but when I
try to submit the form to I have the error Infopath can not access to
datasource Access denied,
Thanks

 

[Aly Esparza]

Thank you I got it, I set the form tamplate not to damain to FULL and it worked