Section 9. Reestablishing Links When a SharePoint Site Has Been Moved

You or someone else might at some time need to move a SharePoint site to a different location. When this happens, the link from Access to the SharePoint data will be lost. Fortunately, Microsoft Office Access 2007 has a built-in feature that enables you to rectify the link. Here's how it works:

1. Click to select the External Data tab within Microsoft Access 2007.
2. After clicking the Work Online button on the toolbar to take the database back on-line, click the Relink Lists option in the SharePoint Lists group. The Relink Lists to New Site dialog appears (see Figure 74).
   

   Figure 74. The Relink Lists to New Site dialog allows you to designate the new site where the lists reside.

   

3. Type in the name of the new site that contains the designated lists.
4. Click Get Lists to view the lists available on the designated site. The lists appear in the New Lists column and Access attempts to map the old list names to the new list names (see Figure 75).
   

   Figure 75. Access attempts to map the old list names to the new list names.

   

5. Click OK to complete the process.