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
Nice post. Here’s how you can move or convert Microsoft Access to web in minutes
Work with access databases via ms access fix software