Integrating Microsoft® Office Access 2007 and Microsoft® SharePoint Server 2007

Section 5. Opening Access Forms and Reports from a SharePoint Site

In the preceding section, we published data to a SharePoint site. When we ran the wizard, we did not opt to save a copy of the database to the SharePoint site and create shortcuts to Access forms and reports. Instead, we ran all the queries, forms, and reports from within Microsoft Access. In this section, we tell the wizard to save a copy of the database to the SharePoint site and create shortcuts to its forms and reports (see Figure 16). To do this, you must select Browse and indicate the location of the document library where you want to save your database (see Figure 17). After you have saved your database to the document library, you can easily launch your forms and reports ...