次の方法で共有

Publish your Access database to SharePoint

  • [アーティクル]

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., https://sharepoint/teamsite/), NOT the top level of your SharePoint site (https://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

  • Anonymous
    January 24, 2012
    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

  • Anonymous
    February 06, 2012
    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

  • Anonymous
    April 26, 2012
    The comment has been removed

  • Anonymous
    October 14, 2013
    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.