Manualshelf

Datasheet

ManualsBrandsWiley ManualsSoftware978-0-470-58716-4
15161718192021222324
Book IV
Chapter 1
Publishing Access
Applications
627
When you open your Access Web database application from SharePoint, you
are (in effect) opening an offline copy of your database application. But not
to worry: Any changes you make while offline can be synchronized back to
the server.
Opening the database from the Site Settings page
Here’s how to open your published Web database application in Access:
1. Using your browser, navigate to your SharePoint Web database site.
2. From the Options menu, click Settings to display the site settings page.
If you haven’t defined a default Web display form for your site, you’ll
be staring at the Site Settings page (which will have appeared in Step 1)
until you specify the pesky Web display form. Humor the machine and
move on.
3. Click the Modify this Web database, add new fields, customize forms
and reports link.
The File Download dialog box appears.
4. Click Open.
The Web database application opens in Access 2010. You can custom-
ize the database as needed. When you’re ready to push your changes
up to the server, flip ahead to the “Synchronizing your changes with
SharePoint” section of this chapter and follow the instructions we left
there.
Opening your database from the Options menu
You can use the following instructions to open your published Web database
application in Access:
1. Using your browser, navigate to your SharePoint Web database site.
2. From the Options menu, click Open in Access.
The File Download dialog box appears.
3. Click Open.
The Web database application opens in Access 2010. You can custom-
ize the database as needed. When you’re ready to synchronize your
changes with the server, follow the steps in the “Synchronizing your
changes with SharePoint” section of this chapter.
You can’t use SharePoint Designer to open a Web-database SharePoint site.
Instead, you have to use Access — just as you do if you’re going to change
or customize your database application.
Publishing to Access Services
31_587164-bk04ch01.indd 62731_587164-bk04ch01.indd 627 9/30/10 8:09 PM9/30/10 8:09 PM