Do You Love Access? We do too!

And that's why there's all the new-and-cool documentation about how to make your InfoPath forms work well with Access:

• Design a form template that is based on a Microsoft Access database
• Add a data connection to a Microsoft Access database
• Submit form data to a Microsoft Access database
• Use values from an Access database to populate a list box, drop-down list box, or combo box
• Change the main data connection to another Microsoft Access database

And a few bonus articles, also from our friends in the documentation team:

• Design a form template for offline use
• InfoPath 2007 XSF Schema Reference

Happy Friday!
Alex

Comments

• Anonymous
  March 18, 2007
  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.

• Anonymous
  March 18, 2007
  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

• Anonymous
  October 02, 2012
  All references I find regarding using a form to submit data to an Access Db are for Access 2003 or in this case 2007.  When adding data connections in the IP form for submit, I can NOT find any way to submit data to an Access 2010 DB.