<div>
Upgrading to SQL has many benefits and would certainly be my choice.<br />
<br />
Are the forms browser enabled?<br />
<br />
Your best bet will be to use web services and sql.
</div>


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.

<div>
Yes the forms are browser enabled. &nbsp;Is there any advantage to submitting the forms directly to sharepoint server and not SQL or Access. &nbsp;I could then link the sharepoint table.
</div>


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.

<div>
<div class="content wysiwyg-content">
I'm using Infopath 2007, receiving and submiting data to MOSS 2007, SQL Server &amp;&nbsp;Access 2007. &nbsp;I am designing a form and would like to submit directly to Access. &nbsp;I notice the Data Connection Wizard does not allow Access as an optional &quot;new connection&quot; to submit data. &nbsp;When I open a new file&gt;Design a New Form Template&gt;Select Database it works fine.<br />
<br />
The form I'm having trouble with was and is intended to be used on a Sharepoint site using Forms Services. &nbsp;<br />
<br />
Do I need to upsize my Access to SQL? &nbsp;I'm comfortable with Access and would like to stay.<br />
<br />
I know I can keep go directly to the MOSS, however, it seems to make sense to go directly to the Access Table?
</div>
</div>


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?

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.