Access and SharePoint Applications

Abstract

Chapter 9 provided an overview of Windows SharePoint Services (WSS). In this chapter, we will again be looking at WSS, but this time concentrating on its interaction with Microsoft Access. From my own contact with developers, I believe many are still confused as to how WSS is designed to fit into the Access development world, and this chapter should help in answering that question. We will kick off by looking at linking to WSS lists and working with them in Access. Then we will move on to migrating an Access database (Northwind 2007) to WSS and look at working with WSS objects in code. However, most Access developers will not be working in code with WSS data; instead, they will be using built-in features of Access, queries, forms, and reports to build rich applications containing WSS list data.