3.8. Using Access 2003 with SharePoint Services

Access 2003, when teamed with SharePoint Portal Server or SharePoint Team Services 2.0 can provide some pretty awesome data sharing capabilities. Both flavors of SharePoint (Portal Server and Team Services) have the ability to share and track Microsoft Office documents among multiple users. And, with built-in document check-in/check-out, version tracking, subscription services, e-mail updates and alerts, Windows SharePoint Services (WSS) makes it easy to share and manage information. It can even be used to ensure that users are automatically kept up-to-date on their projects.

By making it easy to create a Web site that manages information in one central location, WSS dramatically improves team collaboration. And as it becomes more popular, companies will want to do more complicated things with the online data that is offered at a Web site. For example, printing mailing labels for a selected group of contacts. As you probably know, printing directly from a Web site has inherent challenges. But, Access reports are specifically designed for printing. By integrating Access with WSS, you have the best of both worlds. You can easily collect, store, and share data at a central location using WSS, and you can easily manipulate that data with Access.

So, if you are familiar with SharePoint capabilities, you can start getting excited about using Access to tap directly into its power and convenience. Using Access 2003, you can directly import ...

Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.