Access 2010 FAQ
Can I upload my own custom web template to the server and instantiate it?
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 Site Settings from the drop-down menu list, as seen in the following screenshot.
SharePoint opens the Site Settings page with lots of options. We want to navigate to the Solutions Gallery so click the Solutions link under the Galleries category, as shown in the following screenshot.
You should now be on the Solutions Gallery page. To upload your custom web ACCDT to the server, click the Solutions ribbon tab, and then click the Upload Solution command in the New group, as shown below.
SharePoint opens the Upload Document dialog box, as shown in the next screenshot. Click the Browse button to browse to the location of your custom ACCDT file. Click OK once you've selected your file.
After you upload your ACCDT, you are taken back to the Solutions Gallery page where you should now see your ACCDT listed. You're not done yet though. In order to see this ACCDT on the Create New Site page on the server, you first need to activate this solution. To do that, click the arrow next to your ACCDT on the page and select the option called Activate from the drop down menu, as seen in the screenshot below. You can alternatively click the specific ACCDT and then click the Active button in the Commands group on the ribbon.
SharePoint opens the Solution Gallery - Activate Solution dialog box. Click the Activate button in the Commands group on the ribbon to activate your ACCDT on the server, as seen in the screenshot below.
Please note: If you don't have the Activate option, your ACCDT was probably not wrapped inside the SharePoint WSP package. To check, hover over your file name in the Solutions Gallery and look at the Status Bar in the lower left corner of your screen. If the file path does not have .WSP at the end, you won't be able to activate the solution because most likely it is an invalid web ready ACCDT.
You should now be taken back to the Solutions Gallery page once again, but now you'll notice your ACCDT shows the Status as Activated. The following screenshot shows an example.
You're now ready to instantiate the template and create a new Access Services site.
Navigate to the home page on your SharePoint server 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. You'll also see your custom web ACCDT displayed in this dialog. Select your custom web ACCDT template, enter a name for your site, and then enter a URL for your site. In the screenshot below, I've selected to instantiate my custom ACCDT called ContactsMap. You'll notice the right side of the dialog displays the custom description I defined for the ACCDT when I created it in Access client.
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. You can also instantiate the custom ACCDT multiple times to create additional Access Services sites.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page