Publish your Access database to SharePoint

Publish your Access database to SharePoint

  • Comments 4
  • Likes

If you have an Access database sitting on your hard drive that you want to share with a larger team, one of the quickest and most flexible options is to publish it to a SharePoint site using Access Services.

If you don't already have a database, you can quickly create one from a template. In Access 2010, click File, New and Sample templates:

Sample database templates

I selected an Issues Web Database:

Issues Web Database

Once you've made your choice, click the Create button:

Create

If you like, you can enter any data you need to get your database started or do this once it's shared - your choice. When you're ready to share it, click File, Save & Publish, and Publish to Access Services:

Save & Publish

On the right side of the pane, enter the Server URL to your SharePoint Team Site:

Publish to Access Services

Notes:

  • Enter the top level of your Team Site (e.g., http://sharepoint/teamsite/), NOT the top level of your SharePoint site (http://sharepoint).
  • Make sure you select the right place! Once the process is complete, the database on your SharePoint will become the primary database and the Access file on your hard drive will be a secondary linked database.
  • Access will create a backup of your database file in case you do make a mistake and need to try again - though you should probably make your own backup, just in case!

When you've confirmed the Server URL, click the Publish to Access Services button.

To find your database, go to your SharePoint Team Site and click View All Site Content:

View All Site Content

Scroll down to the Sites and Workspaces section to find your database:

Sites and Workspaces

Click the link to access it and then click Options to manage permissions and share with colleagues:

SharePoint database options

Suzanne

Comments
  • Nice post. Here’s how you can move or convert  Microsoft Access to web in minutes

    www.caspio.com/.../convert-ms-access-to-web.aspx

  • I would like to know what is a sharepoint. For example when I do not have access to the server which sharepoint I can use?

    Please help me with this bcause i' ve tried using 'http://localhost' and failed.

    Thanks

  • Access 2010 really has come a long way. I'm so glad I stuck with it.

    Paul Harrold <a href="http://www.comcraft.co.uk">Microsoft Access database developer</a>

  • Is it possible to publish an access database from several different SharePoint sites?  Currently using WSS 3.0 but due to upgrade in a few months.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment