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.
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.
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 ...