Connecting InfoPath Forms to access and sharepoint

[Dr. Crafton]

I am using InfoPath 2007 to create a form so multiuser can fill out the
information for trading up their computer system. I want store this
infomation in an access 2007 database. In addition, I want to place the form
on a sharepoint server site so it can be accessible to many users.

I established a data connection between the form and access database. When i
try to submit the information, I get this warning-"The form does not contain
any new data to submit to the data source. I do not understand this message.
I am new to infopath 2007 and access 2007.

 

[Hilary Stoupa]

Hi:

At its most general level, this error means exactly what it says -- that it
is looking at the data in the fields that are being submitted to the database
and it doesn't see any changes.

That being said, to help you figure out why you are getting the error, I'll
need a little more information. When you designed your form, did you base it
off the database? Or are you using code or a web service to submit your data?

If you based off your database, are the fields on your form bound to the
data fields in your schema?

 

[hammey22]

Hilary,

I am having the same issue, however I am using IP2003. I am basing my form
off of db schema, but I am using some additional fields that I added that are
only being submitted to a SharePoint list. If I update any fields that are
in the db I am fine, no error on Submit. If I only update fields that were
added to the form where IP is the datasource then I get that error. I could
always add a submit button that only pushes data to the SharePoint, but I
want to avoid confusing my users. Adding the fields that are being written
to the SP in to the db is not an option since they often times exceed 255
characters. Unless you have a way to allow memo fields to be used???

 

[Hilary Stoupa]

One idea could be to create an additional field (a boolean value maybe) and
then if any of the data fields connected with the access database change, you
could set the field to true. Then, in the rules for the submit for the access
connection, only run that submit if the boolean field is true.