Datasheet

628
Synchronizing your changes with SharePoint
After you’ve initially published your Access Web database to Access
Services, the way you synchronize all subsequent database modifications
and customizations with SharePoint is to use the Sync All command in the
Access client application.
Here’s how to synchronize your database application changes to SharePoint:
1. Open your Web database application in Access 2010.
2. Click the File tab to present the Access Backstage View.
3. Click the Info tab.
General options relating to your application appear, including the syn-
chronize options.
4. Click the Sync All command to synchronize all your changes with the
server and reconnect all the tables.
The Synchronizing Web Application dialog box appears, showing you a
status bar so you can keep track of the conversion process.
Saving your Web Database as a Site Template
The integration between Microsoft Access 2010 and Access Services makes
it easy to create an Access Web database template and implement it as a site
template in SharePoint. SharePoint Server 2010 implements site templates as
solution files (.wsp). If you haven’t created a solution file yet, don’t despair;
there’s an easy way . . .
With Access 2010 handy, you don’t have to figure out how to package your
database as a SharePoint solution file. Instead, you wave your magic wand
(well, almost): You simply save your Web database as a regular Access tem-
plate file (.accdt) and upload it to the SharePoint Solution Gallery. When
you upload an Access database template to the SharePoint Solution Gallery,
Access Services kicks into gear and wraps the template in a SharePoint solu-
tion file — automatically. (Gotta love it.)
Here’s the process that deploys your Access Web database as a SharePoint
site template:
1. Open your Web database in Access 2010.
2. Click the File tab to present the Access Backstage View.
3. Click Save & Publish, and then click Save Database As.
A list of database file types appears on the right, under the Save
Database As section.
Publishing to Access Services
31_587164-bk04ch01.indd 62831_587164-bk04ch01.indd 628 9/30/10 8:09 PM9/30/10 8:09 PM