• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

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

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?
  • 2
1 Solution
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.
ojespinosaAuthor Commented:
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.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now