Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Change Main Data Connection To Another. The Server Name given in he below settings are Jr-erpsrv-02. Change a data connection On the Tools menu click Data Connections.
A data connection is a dynamic link between a form and a data source that stores or provides data for that form. 1 Connection Type. But it doesnt work.
The main data connection defines the main data source of the form.
Connection information can either be stored in the workbook or in a connection file such as an Office Data Connection ODC file odc or a Universal Data Connection UDC file udcx. On the Data Source page drag a table to the canvas to set up the data source if this is not automatically done for you. You can change the main data connection of a database form template to submit to another table But when it comes to the list form template the main data connection is greyed out. List form is special You cannot change the publish location after creating the form Nor can you modify the main data connection This is by design So I would suggest create another.