Access™ 2007 Bible

Chapter 23. Integrating Access with SharePoint

IN THIS CHAPTER

• Getting familiar with SharePoint

• Knowing what a SharePoint Service is

• Understanding SharePoint Portal Server

• Looking at SharePoint applications

• Seeing the integration of a SharePoint Service with Access 2007

• Looking at how operating systems work with SharePoint

• Working with SharePoint Lists

Access and SharePoint can be transparently integrated, seamlessly sharing data across the Internet. Access data can very simply be linked to, or copied from, a data source located on a SharePoint Web site. The result is data stored on a SharePoint Web site somewhere, appearing to be stored in a table in Access. The connection between SharePoint Services and an Access installation can be executed over a TCP/IP connection. This means that the connection can run over the Internet. So, in technical terms, the overall result is that SharePoint can provide an external source of data to Access, similar to how an external database such as SQL Server can provide data to Access, over an ODBC connection.

Note

This chapter uses the Chapter23.accdb database. If you haven't already copied it onto your machine from the CD, you'll need to do so now.

What Is SharePoint?

SharePoint is essentially a storage framework (at a specific location), where information can be shared across a network. Current implementations of SharePoint are typically local area network (LAN) implementations within a company, sometimes shared with client or partners. SharePoint is primarily ...