InfoPath Dev

I have a access database with about 15 fields. This is stored on a T drive. I also have created a infopath form that is NOT connected to a database with 200+ fields. This form when submitted is saved to a portal library that our people review. I now need to create a button that when they update the fields they will be saved over the old form but I then need the 15 matching fields to send the data to the access database. In short I need only the 15 fields connected to a database.

Hi - the only way I know to do this with a form that is not based off the Access database is with custom code, unfortunately. You can add fields to a database bound form, as long as you add them to the root node - but that doesn't help you with your existing forms that are probably already filled out.

If the data can be moved to SQL, the company I work for sells a web service makes submitting data from an existing form to a database much simpler.

I wonder - if the fields are promoted properties in the library, perhaps you could do something with a custom workflow - write the values to a list, and link another table to the list... then have some other logic that updates the DB ...