locked
InfoPath 2007 - No SharePoint - Static Web Page RRS feed

  • Question

  • I do not have access to SharePoint, so there are no workflows.  I have maintained a InfoPath form and want to save the data in either SQL Server or Access.  The form would be hosted on the server and the different approvers of the form will be e-mailed a link to the form.  Any suggestions?  TIA!

    David L. Crooks

    Tuesday, April 2, 2013 2:01 PM

Answers

  • Hi,

    I understand that you want to submit the data on a form to database using InfoPath 2007 form. Only forms created using database template can submit to database. So you need to create the form template using the database template. Then  change the compatibility for the form.

    1. Open the template in InfoPath and click Tools> Form Options.
    2. Under Compatibility, uncheck ‘Design a form template that can be opened in a browser or InfoPath’.
    3. Modify the Main data connection to allow submit.

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming
    TechNet Community Support

    Wednesday, April 3, 2013 6:43 AM
    Moderator