InfoPath Dev

I have an infopath form connected to an access 2007 db and a filed in access is an attachment field to save the pictures in.

Now when I add the picture field from the controls pane to the form, the submit button dissappears. The data connection has disabled submit becuse infopath does not support long integer types etc etc.

How can i get the form to accept a user inserted picture and have it submitted to the database after all, the fields & controls are shipped with infopath so surely they should work? 

When I remove the control, hey presto!! - the submit button comes back.

Forms designed off of a database allow you to submit right back to that same database.

If you want to modify your form's schema (for example, by adding a new field) that data cannot be submitted to that same database.

You'll need to write a web service that submits to the database.

Previous discussions all point to similar solutions:

(a) You create a db-bound form.

(b) You write your own web service.

(c) You use a tool like DBXL to map the data. Unfortunately, this is for SQL only, not Access.

This is a great post which covers b and c. Good luck!