Collecting Data via E-Mail

Access 2007 introduces a new feature that allows you to collect data through e-mail and import it into your database. The data is collected through either HTML forms or rich Microsoft Office InfoPath 2007 forms. Access 2007 allows you to either update existing data in a table or add new records to a table. By integrating Access 2007 with e-mail collection capabilities, you can have users update and add information to your database from different locations. This feature can be used, for example, in a club membership application that periodically needs to update its member records.

To use the e-mail data collection capabilities in Access 2007, you must also have Microsoft Office Outlook 2007 installed to send the data entry ...

Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.