Link to home
Create AccountLog in
Avatar of ojespinosa
ojespinosa

asked on

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?
Avatar of Robbie_Leggett
Robbie_Leggett
Flag of United Kingdom of Great Britain and Northern Ireland image

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.
Avatar of ojespinosa
ojespinosa

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Robbie_Leggett
Robbie_Leggett
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account