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.

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

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

    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

  2. Cameron Reid says:

    Nice post. Here’s how you can move or convert  Microsoft Access to web in minutes…/convert-ms-access-to-web.aspx