Access 2010: The Missing Manual

Publishing a Web Database

So far, you’ve learned to create a basic web database. But until you upload that web database to a SharePoint server, it isn’t fulfilling its true potential (and you have no way to run your web objects in the browser).

Publishing a web database is easy:

1. Choose File→Info.

   You arrive in backstage view, where you see a big “Publish to Access Services” button that doesn’t appear when you’re dealing with an ordinary database.

2. Click “Publish to Access Services”.

   This command takes you to the File→Save & Publish section of backstage view, with the “Publish to Access Services” option already selected (Figure 23-6).

   

   Figure 23-6. In the Save & Publish section, you can do two things: check the web compatibility of your database, or publish it to a SharePoint server (circled). There’s no reason to run the Compatibility Checker unless you’re working with an ordinary database. If you created a web database, you already know that it’s free from compatibility problems.

3. Fill in the Server URL and Site Name boxes.

   The Server URL is the name of your SharePoint site. (As you already know, this could be a location on an internal network, or a website on the Internet.)

   The Site Name is the site that you want to create for your database. It’s also where SharePoint will store the hidden lists that make up your database. As you learned in Chapter 22, every SharePoint site can hold an unlimited ...