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

x
?
Solved

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

Posted on 2007-10-06
3
Medium Priority
?
488 Views
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?
0
Comment
Question by:ojespinosa
  • 2
3 Comments
 
LVL 25

Expert Comment

by:Robbie_Leggett
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.
0
 

Author Comment

by:ojespinosa
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.
0
 
LVL 25

Accepted Solution

by:
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.

:-)
0

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