I recently discovered MS Infopath and have spent several days tring to learn it and design a form that will populate an Access database. I have encountered some hurdles that I need help with:
1) I have a form designed that has a data connection to an Access database in a shared network folder. My purpose for this is that when someone fills out the InfoPath form, the data will go into the Access database. But when I fill out the form, this does not work???
2) When I go to Tools, and then Submitting Forms, online tutorials tell me that I should have a "Submit To: Access Database" option, but I do not have this, even though my form has the data connection to the Access database in the shared network folder. Am I doing something wrong or can you not directly submit data from an InfoPath form (on a shared file area) into an Access database?
So in conclusion, I made a form, and published the form to a shared file area. When I fill out the form it asks if you want to save the data, where I clicked yes, but this just saves the form as a .xml document in the same folder. I can also get the form data as an email.
But it does not do me any good to see the form data in a .xml or email document.....how can I get data into an Access or Excel table?
The reason I wanted to use InfoPath is to create a simple form online (on a webpage) and have people fill out surveys, and I can collect the data in an Access or Excel database.
Thanks.