O'Reilly logo

Access 2003 VBA Programmer's Reference by Armen Stein, Graham Seach, Teresa Hennig, Patricia Cardoza

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

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

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