How to publish Access database on a SharePoint Enterprise site (SharePoint 2010)

  • Synopsis

    This guide will show you how to publish Access database on your SharePoint 2010 Enterprise site.
  • Applicable to

    All PlexHosted SharePoint 2010 Enterprise accounts.
  • Prerequisite

  • How to

    Method 1-
    1. Start Access 2010. Access displays the Microsoft Office Backstage view. This allows a new database to be created.
    2. Open an existing database or create a new database. To create a new database select the New tab in the left navigation pane and then select Blank Web database from the Available Templates. Creating a Web database helps ensure that the features used by the database will be compatible with the Web publishing feature. Specify name of the database and click Create.

    3. Edit your database tables as required. Click tab File.

    4. At the File tab click Save&Publish and then click Publish to Access Services.

    5. The Access Services Overview pane will be displayed, offering options to check the database for Web compatibility and publish it to Access Services. The compatibility checker allows the database to be tested to verify that it has no items or settings that would make it incompatible with Access Services. In this case, because the sample database is based on the Web Database template and the solution is designed to be simple, skip this step. In the Publish to Access Services section, specify your Server URL (the URL of your SharePoint site where you will publish the database) and Site Name (any name of the Site Collection where you want host your database) and then click the button Publish to Access Services.

    6. SharePoint prompts for your connection credentials. Enter the name and password of a user who has permission to create new sites on the SharePoint Site and then click OK. Access processes the objects in the database and publishes it to SharePoint, synchronizing the local copy of the database that has the data stored on the server.
    7. When the database is published, Access displays a Publish Succeeded message that has a link to the new Web database application. Click Ok.

    8. Type the database URL at your web browser (recommend using Internet Explorer). You will see your database at the SharePoint 2010 Site. Access Services displays the navigation form.

    Method 2-
    1. Start Access 2010. Access displays the Microsoft Office Backstage view. This allows a new database to be created.
    2. Open an existing database or create a new database. To create a new database select the New tab in the left navigation pane and then select Blank Web database from the Available Templates. Creating a Web database helps ensure that the features used by the database will be compatible with the Web publishing feature. Specify name of the database and click Create.

    3. Edit your database tables as required.
    4. Select the table name and right mouse click. Select Export at the drop-down menu and then select SharePoint List.

    5. Specify a SharePoint site URL. Specify a name for a new list and then click OK button.

    6. When the database is published, you can save the export steps by selecting Save Export Steps. Click Close.

    7. Type the database URL on your web browser (recommend using Internet Explorer) and see your database at the SharePoint 2010 Site.

    If you need further assistance, please do not hesitate to contact the PlexHosted support team.

  • Keywords

    SharePoint, Access, publish database, Enterprise feature, publish access
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to enable workflow visualization at the SharePoint site (SharePoint 2010)

Synopsis This guide will show you how to enable workflow visualization at the SharePoint...

How to create and publish InfoPath template to a SharePoint Enterprise site (SharePoint 2010)

Synopsis This guide will show you how to create and publish InfoPath template to a...

How to create a new navigation form in Access 2010 and set it as default display form (SharePoint 2010)

Synopsis This guide will show you create a new navigation form in Access 2010 and set it as...

How to publish Microsoft Visio 2010 Diagrams (SharePoint 2010)

Synopsis This guide will show you how to publish Microsoft Visio 2010 Diagrams...

How to publish an InfoPath form to the SharePoint list (SharePoint 2010)

Synopsis This guide will show you how to create and publish an InfoPath form to the...