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