Access™ 2007 VBA Programmer's Reference

17.4. Summary

Microsoft Windows SharePoint Services is one of the fastest growing group collaboration tools in the world, and Microsoft Office 2007 provides a slew of new features for working directly with SharePoint. Access developers now have the capability to leverage much of the rich tool set that SharePoint provides by developing Access applications that harness the SharePoint technology. As you've seen in this chapter, most of those features are simple to incorporate into almost any Access application.

The Access Web Datasheet enables users to edit multiple records in the SharePoint list directly from their Web browsers. They can export or link SharePoint list data to an Access database quickly with features such as the Open with Access button or the Web Datasheet task pane. Access 2007 also supports importing and linking to more SharePoint data types than ever before, and these new entry points are much more discoverable. Developers creating or migrating existing Access solutions can easily perform this operation using the Move to SharePoint functionality. Users can publish databases to a SharePoint site, allowing them to be used in Access applications in the same manner as working with other Office documents on a SharePoint server. And last, but not least, you can create Access Views that invoke Access applications automatically when the view is selected from the SharePoint site.

With all of these features, running Microsoft Windows SharePoint Services 3.0 with Microsoft ...