Access, SharePoint, and SharePoint Designer

Abstract

Microsoft Access 2007 is missing support for two technologies used by developers who want to get data onto the Internet: Active Server Pages (ASP) and Data Access Pages (DAPs). Never being a great fan of DAPs, I will not miss them. When I first started out with Access and the Web, I made great use of the Save As ASP feature in Access to make simple datasets available. In this chapter, we will be looking specifically at what more you can do once you have your Access application on Windows SharePoint Services (WSS) and how you can use the replacement to FrontPage 2003, SharePoint Designer (SPD), to make your data available via the Internet. SPD is designed to work directly with SharePoint and can be used as a design and development tool when communicating with WSS sites. However, you can also use SPD to create standard web pages displaying data from Access 2007. In this chapter, you will learn about both options.