InfoPath Dev

Hi --

To create a form that submits to an Access (or SQL) database, you have to select that database when you first create the form (in the Based On section of the dialog box).

However, there are various reasons why, even if you did this, submit may be disabled for your form. This information will be present in the last window of the database connection wizard, when you set up your initial connection, or when you walk through it again, from the Tools / Data Connections window (select Modify, and you can walk through the connection steps again).

It is very easy to overlook this information. On the final screen, where you have the option of naming your data connection, there will be a checkbox you can use to enable submit. If that box is disabled, in the description of the data connection below, you'll find information on submit status, along with any reasons you aren't allowed to submit. The most common mistake is that the table you wish to build the form off of doesn't have primary keys set up on the table....

Hope that helps!

Thanks for the reply.

 I used "New From Data Connection" when first designing the form and connected it to an Access database in a network folder.

When I go to Tools/Data Connections, one of the Connections shows that the form is connected to this database.

 But I still don't see the database option in the Submitting Options section. I setup the primary key in the Access database table after I had already made the initial connection between InfoPath and Access...is this a problem?

 Where is the Based On section of the dialog box, or is this the same as the New From Data Connection option?

 Two other newbie questions)

Also, why does Infopath create an .xml file each time a survey is filled out? If we fill out 100 surveys, do we have to worry about atorage space for 100 .xml forms

And are there free WebServices available that one can use if publishing form to a website?

Select the data connection in Tools / Data Connections that is the connection to your Access Database. Click the Modify button. Walk through the Data connection wizard again. When you get to the last screen, where you can enter the name of the data connection, look for the Enable Submit checkbox. Is it disabled? If so, read all the information displayed below that check box. There will be a message explaining why Submit is disabled.

Once you have your form set to submit to your database, you'll be able to set it to close on submit and the user won't have the option to save the xml file -- you can also set the form not to allow Save or Save As under Tools / Form Options. As far as the last question -- I'm afraid I don't understand it. Can you explain a bit more?

Thanks for the reply. I will do what you suggested.

 The last question was about WebServices. Is a WebService just a server connection that you need to publish an InfoPath form to a website? Since I do not have any server/internet publishing priveleges at my organization, do I need to ask my IT department to see what WebService they use and if I can link it with InfoPath?

I did as you said and now its working, so Thank You.

I could not submit to database earlier because multiple tables were being used.