If you are trying to deploy a Sharepoint 2010 site template based on a Access Web Database & you see the following error:

Preparing Site …

Wait a moment and refresh your browser

You probably havent set up your Access service application:

Create a Access Service Application
(Central Administration –-> Manage Service Applications –-> New –-> Access Services)

Started the Access Database Service
(Central Administration –-> Manage Services on Server)

Now open the SharePoint 2010 Management Shell and enter:

enable-spSessionStateService –DataBaseName <NameOfYourNewDatabase>

This creates a session state database and turns on the session state service.

Outlook-Style Calendar Room Booking System using Access Services in Sharepoint 2010

Room Booking System using Access Services

More From pstilgoe

• Sharepoint 2010: How to hide the quick launch menu
• Sharepoint 2010 CQWP: Make the CQWP portable by using tokens to point to the current site instead of static URL
• Sharepoint 2010: Sample CSS to customise Site Actions button

Ask pstilgoe To Recommend Your Posts

With Access 2010, you can move your tables to SharePoint, and create end-user forms in Access that will show up in SharePoint as a special site. The MS Access 2010 web forms have a similar look and feel to normal SharePoint pages, and you will need to design your web forms in MS Access 2010 separately from any client forms you want to display to users when they view your database using Access on their own machine. The formal name for the feature is “Access Services,” but expect it to be replaced by something more descriptive and less “techie” in the years to come.

http://www.opengatesw.net/ms-access-tutorials/Access-2010/Microsoft-Access-2010-Access-Services-Overview.htm

http://curriersblog.spaces.live.com/blog/cns!1FE2EFF5F31CEDCA!449.entry

http://workerthread.wordpress.com/2010/01/16/thoughts-on-access-services-in-sharepoint-2010/