[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2007-10-06
Medium Priority
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
  • 2
LVL 25

Expert Comment

ID: 20033106
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

ID: 20035945
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

Robbie_Leggett earned 2000 total points
ID: 20039186
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.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

872 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