Show All

Update the main data connection to a database or Web service

When you design a new form that is connected to a database or Web service, Microsoft Office InfoPath 2003 builds a data structure for your form based on that database or Web service. If the database or Web service is then changed or moved, you can update your form so that it uses the updated database or Web service.

1. In design mode, click Convert Main Data Source on the Tools menu.
2. Follow the steps in the Data Connection Wizard to update your form's data connection.
3. Revise the form to match the updated database or Web service. If a field has been removed in the updated database, for example, rebind or remove the controls that were previously bound to that field.
4. Test the form thoroughly.

   Note  Testing the form includes previewing the form, as well as opening a new form and filling it out. Make sure to test any controls bound to new or modified fields.

5. If users have already filled out forms based on this form, upgrade those existing forms.

   How?

   1. On the Tools menu, click Form Options, and then click the Advanced tab.
   2. In the On version upgrade list, click Automatically upgrade existing forms.
6. To republish the form, click Publish on the File menu.