Integrating Microsoft

Section 10. Modifying the Design of an Access Database Stored on a SharePoint Server

When you move a database to a SharePoint site, Access gives you the option of whether you want to move the database containing the forms and reports to SharePoint, too. If you opt to do so, changes that you make to the design of the database objects (forms and reports) will be made in a local copy of the database. When you have completed those changes, you must update the copy of the database on the SharePoint server with those changes. Here's the process:

1. Make the desired changes to the forms and reports in the local copy of the database.
2. Click the Publish to SharePoint Site button (see Figure 76). The Publish to Web Server dialog appears (see Figure 77).