Submitting Data with Infopath 2007 form to Access, SQL or MOSS 2007

Posted on 2007-10-06
Last Modified: 2012-05-05
I'm using Infopath 2007, receiving and submiting data to MOSS 2007, SQL Server & Access 2007.  I am designing a form and would like to submit directly to Access.  I notice the Data Connection Wizard does not allow Access as an optional "new connection" to submit data.  When I open a new file>Design a New Form Template>Select Database it works fine.

The form I'm having trouble with was and is intended to be used on a Sharepoint site using Forms Services.  

Do I need to upsize my Access to SQL?  I'm comfortable with Access and would like to stay.

I know I can keep go directly to the MOSS, however, it seems to make sense to go directly to the Access Table?
Question by:ojespinosa
    LVL 25

    Expert Comment

    Upgrading to SQL has many benefits and would certainly be my choice.

    Are the forms browser enabled?

    Your best bet will be to use web services and sql.

    Author Comment

    Yes the forms are browser enabled.  Is there any advantage to submitting the forms directly to sharepoint server and not SQL or Access.  I could then link the sharepoint table.
    LVL 25

    Accepted Solution

    The forms are submitted to SharePoint by default. You can choose to submit data from within the forms to a sql database if you choose, but a webservice is needed to do this.

    It's also worth remembering that all SharePoint data is stored in sql anyway.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
    Outlook Free & Paid Tools
    The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now