RE: submit infopath form to access database

[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.

[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.