And that's why there's all the new-and-cool documentation about how to make your InfoPath forms work well with Access:
And a few bonus articles, also from our friends in the documentation team:
Happy Friday!Alex
Interesting article!
Is there a way to use access to do quick and dirty reporting on a bunch of infopath files? Currently the forms are living in a sharepoint forms library but it would be great to let the business users easily analyse the form data.
If your InfoPath forms submit data to a SharePoint document library, and you use property promotion, you can link up the promoted fields as data connections to Excel or Access, and build reports based on that data. This, of course, has limitations (i.e. you need to flatten out your schema by using aggregate functions), but can get definitely get you the desired outcome for many scenarios.
-Alex
