• 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?
0
ojespinosa
Asked:
ojespinosa
  • 2
1 Solution
 
Robbie_LeggettCommented:
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.
0
 
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.
0
 
Robbie_LeggettCommented:
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.

:-)
0
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