O'Reilly logo

Access Cookbook, 2nd Edition by Andy Baron, Paul Litwin, Ken Getz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Office Web and SharePoint

Data Access Pages represent just one of several options for creating web pages connected to Access databases. You can also use FrontPage 2003, with or without Windows SharePoint Services, to create Access-connected web pages.

Windows SharePoint Services, a server component that is part of Windows 2003 Server, is a great system for easily creating collaborative, team-based web sites consisting of various lists and documents. Access 2003 can work with SharePoint in two ways. First, you can use Access as a frontend to your SharePoint list and documents. That is, you can create a SharePoint management interface using Access forms and reports to help manage your SharePoint sites. In addition, you can use SharePoint to create data-driven web sites that draw their data from Access databases and display the data using the Data View Web Part.

FrontPage 2002 and 2003 also allow you to connect web sites to Access databases without using Windows SharePoint Services. You can use FrontPage to create an HTML form that sends its results to an Access database. You can also use the FrontPage Database Interface Wizard to quickly create a frontend to an Access table.

15.1. Work with SharePoint Data from Access

Problem

Windows SharePoint Services makes it easy to create collaborative, team-based web sites consisting of various lists and documents. Is it possible to use Access as a frontend to SharePoint data?

Solution

Tip

This solution requires Access 2003 and a web ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required