none
Access Services in SharePoint 2010

    Question

  • Hi,

     

    I just installed Access Services onto our SharePoint 2010 Server. At least I think I did. I have not been able to find a guide for installation. Access services were installed by way of the “Enable Enterprise Features” portion of Upgrade and Migration. After this completed (successfully) I used the feature to apply the upgrade to existent sites. That too completed successfully. Under Central Admin/Services on the server, Access Database Services shows that is installed and started. But as a note here, after the install completed I did a restart of the server and after the restart the  Access Database Service did not start automatically. How is this toggled to start automatically?

     

    Also, I added Access Services Application to Central Admin/Service Applications.

     

    When I tried to use Access 2010 to publish to SharePoint, Access provided the following notification:

     

    https://[ourSharePoint site/] did not respond. Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older version of Microsoft Access services that is not compatible with Access 2010”

     

     

    So my questions are:

     

    1)      Is there a guide for installing Access Services on SharePoint 2010?

    2)      Is there a particular kind of site that I need to have in place to permit or better facilitate Access databases?

     

     

    Thank you!

    Wednesday, March 30, 2011 12:21 AM

Answers

All replies

  • I found the following link to be very informative

    http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/4cb01c68-4924-44a1-b31b-0f2c3fc1b16d

    but could not identify the reason for the problem referenced above.

     

    1)      Is there a guide for installing Access Services on SharePoint 2010?

    2)      Is there a particular kind of site that I need to have in place to permit or better facilitate Access databases?

     

    Thank you.

     

    Wednesday, March 30, 2011 6:39 PM
  • Hello,

    there are different possibilities why you might experience this. It would also be good to know whether you use a single server or a farm deployment. In the latter case, you can run the Farm Configuration Wizard in order to add the Access Services (if they don't exist already). It can be found in Central Administration under "Configuration Wizards".

    1. Are Access Services installed on the server? Verify e.g. using Central Administration -> Manage Service Applications (then check the list for Access Services)

    2. In case, just add a new Access Service Application (Central Administration

    3. Are Access Services connected to the web application? You can check this by the Central Administration -> Manage Web Applications -> Select the row of the desired web application and then click on "Service connections" in the ribbon above. See whether the Access Service Application is checked.

    4. Do you have a site collection based on one of the web databases template? If not, create one (new Site -> Web Databases -> select template).

     

    In general, it is not enough to just connect to your SharePoint server, but you must connect to the correct web application. This web application must have a connection to the Access Service Application.

     

    I hope this helps to get you started. ;-)

     

    Best regards,

    Martin


    Martin W. Angler, MCTS

    Blog angler.wordpress.com
    Twitter: Follow me on twitter
    Wednesday, March 30, 2011 7:09 PM
  • Try my blog link.. It has everything you may need to know about Access Services... it has step by step install and config guide including usecases and full life cycle management..

    http://nikspatel.wordpress.com/2010/08/13/all-you-need-to-know-about-the-access-services-2010/

    Nik


    Nik Patel
    Slalom Consulting
    Blog: http://nikspatel.wordpress.com
    Follow me at http://twitter.com/nikxpatel
    Wednesday, March 30, 2011 7:12 PM
  • Hi,

     

     

    Thank you both VERY MUCH for the detailed feedback!

     

    After reviewing your guides and finding that I’ve done most of what is detailed I was still having the same problem. Then I came across a tutorial in Access that illustrated the steps involved. The key that made the difference was that one has to only specify the address of the server. Previously I was creating a site and trying to upload the database to that site.

     

    So, with that written down, is it possible to specify the location of where we want the site to be created, or is that handled exclusively by SharePoint?

     

    Thanks again!!!

    Thursday, March 31, 2011 9:52 PM