No Access Database Service is available in the farm


I recently installed a new SharePoint 2010 farm to check out some new site templates that I had not yet used. When creating a new Asset Library Web Database I ran into the following error.

Problem:
    “No Access Database Service is available in the farm.”

Cause:
    Asset Library Web Database uses the Access Database Service which was not running by default.

Resolution:
    1. Go to Central Administration Page
    2. Select Application Management
    3. Under Service Applications select ‘Manage services on server’
    4. First item listed is Access Database Service – start this service

 

Comments (2)

  1. Anonymous says:

    Work with access databases via ms access fix software

    http://www.access.fixtoolboxx.com

  2. Cameron Reid says:

    Nice post. Here’s how you can move or convert  Microsoft Access to web in minutes

    http://www.caspio.com/…/convert-ms-access-to-web.aspx