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?