submit infopath form to access database

[infopath-to-access]

i have designed an infopath form and wish to submit it to an access database
on my computer. by going to tools>design form>submit... I can use http or a
script
but i cannot browse to find a database...

what to do?


also, if i try to import the XML infopath-generated form directly into
access by using
Get External Data command, i get erros

 

[Nate]

I think I have a similar problem. I just started teaching myself InfoPath.
I've been able to create forms for SQL Server databases without any problems.
However, for some strange reason when I create a form for Access the 'Submit'
command is disabled most of the time. Anyone have an answer?
Thanks in advance,

 

[Scott L. Heim [MSFT]]

Hi,

If you want to create an InfoPath solution that will submit to an Access or
SQL Server database, then you need to begin designing your solution from
one of those databases. It sounds like you may have chosen to "Create a new
blank form", created the form as you need and now want to submit to an
Access database.

It's not possible to have InfoPath create a database schema from your
InfoPath solution so you need to design your solution "from" one of those
databases.

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Scott L. Heim [MSFT]]

Hi Nate,

If you have designed your InfoPath solution from an Access or SQL Server
database and you do not have the option to "Submit" to a database, it
sounds like your table may have "long value' types of fields, such as: OLE
Object, Memo, etc.

If you have to have these types of fields, you will need to write custom
code to perform the submit functionality. This is not "InfoPath" related
per sé but more "ADO/OLEDB" related, which is the underlying technology
InfoPath uses for accessing data.

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.