Access 2013 Bible

Chapter 33: Integrating Access with SharePoint

IN THIS CHAPTER

Linking to SharePoint lists

Importing SharePoint lists

Exporting Access tables to SharePoint

Upsizing Access databases to SharePoint

Using SharePoint list templates

Several of the previous chapters of this book have touched on different data sources for Access. You've seen how Access supports importing, linking, and exporting data. Access has no equal when it comes to sharing data with other applications.

SharePoint data linked to an Access application is live and reflects changes made by users almost instantly. In reality, SharePoint integration is one of the big stories (from Microsoft's perspective) in Access and Office 2013. Microsoft is busily enhancing the ability of Access and SharePoint to cooperate and share data. SharePoint services can be both local to a specific company or rented/leased from service providers. When a user opens an Access report, at least a portion of the data may be hosted on a SharePoint site many thousands of miles away.

This chapter demonstrates the power and flexibility of using SharePoint data within Access applications.

On the Web

The starting database for this walkthrough, Chapter33.accdb, can be downloaded from this book's website.

Note

You'll need access to a SharePoint server to experiment with the data sharing techniques described in this chapter. If you're interested in using SharePoint, you'll need to contact your IT department to inquire about getting access to a SharePoint ...