Access 2010 FAQ
How do I instantiate a built-in web database on the server?
You'll first need appropriate permissions on your SharePoint server to create new sites. Talk to your SharePoint server administrator if you do not currently have sufficient rights to create new sites.
Navigate to your SharePoint server site using your web browser, and then click the Site Actions button in the upper left corner above the ribbon. Click New Site from the drop-down menu list, as seen in the following screenshot.
If you have SilverLight installed on your computer, SharePoint opens the Create dialog box, as shown below. On the left pane, click Web Databases to display the five built-in Access Services web templates that ship with SharePoint Server 2010. Click one of the five web template icons - Assets Web Database, Charitable Contributions Web, Contacts Web Database, Issues Web Database, or Projects Web Database - and then enter a name for your site and a URL for your site. In the screenshot below, I've selected to instantiate the Assets Web Template.
After you've made your selections and entered your information, click Create. SharePoint starts the process of creating your Access Services application. You'll see the following Processing dialog during this process while your site is being prepared.
After your site is created and all objects compiled, SharePoint navigates you to your completed Access Services application, as shown in the screenshot below. Your site is now ready for use. You can also open this application in Access client and make changes to the database.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page