Upload and Publish Access Database on SharePoint

This tutorial will guide you to upload and publish microsoft access database on sharePoint. SharePoint is web based application that integrates with Microsoft Office, which designed for document management, storage system, and the online, cloud base for document sharing system.

To export your Access Database into SharePoint, you need to install the SharePoint application and create a site in SharePoint. Next, follow these instructions:
1. Open the database that want to be exported. Make sure the database design is final.
2. Go to Database Tools tab > SharePoint.

Access Database On Sharepoint (1)

Access Database On Sharepoint (1)

3. In the dialog box, select the SharePoint site and click Next.
4. Wait until the exporting process finished. Click finish.
5. Now, open your SharePoint site. In Lists, click the database file name to open it.

Aside for exporting the finished, ready to use Access database, you can create the new Access database inside the SharePoint application.
1. Open the SharePoint Application. Open Actions menu > Open in Microsoft Access.
2. Link the data to the SharePoint site.
3. Create the database: tables, forms, query, etc.
Or, you can create new Access Database to SharePoint via Ms Access:
1. go to File > New and choose Custom web app (2013) or Blank Web Database (2010).
2. Rename the App and in the Web Location, input your SharePoint site.
3. Click Create. Now in the blank database, design it.

Read Also:  MS Access Left Function in SQL Query and VBA Code

The first tutorial is to export the database, while the second and third are about create new database for SharePoint application. Now, you can link your database into SharePoint application or more specifically, how to import or linking the database from SharePoint to Access database:
1. Go to External Data tab. Click More > SharePoint List.
2. In the dialog box, select a SharePoint site
3. Choose to Import the source data or Link the data source. Hit Next.
4. If you are not logged in, a SharePoint pop up will appear for Login.
5. After you are logged in, a list of database will appear. Tick the checkbox(es) that wanted to be linked or imported.
6. Now, the imported object will appear in Navigation Pane window. Double click to open it.

Access Database On Sharepoint (2)

Access Database On Sharepoint (2)

Related Access Database

  • build and publish access database to sharepoint access 2016
  • publish access database 2016


Access Database Tags: #access 2013 sharepoint #access 2016 publish to sharepoint #link access database to sharepoint #publish access 2013 database to sharepoint 2010 #publish access 2016 database to sharepoint #publish access database to sharepoint 2013 #publish access database to sharepoint office 365 #upload access database to sharepoint 2013

MS Access VBA Close Workbook and Form
MS Access VBA Close Workbook and Form
In this tutorial, we use Ms Access
MS Access DB and MDB Viewer Software
MS Access DB and MDB Viewer Software
Access DB Viewer is the software to
MS Access Validation Rule Lookup Table Examples
MS Access Validation Rule Lookup Table Examples
The Validation Rule in Microsoft Access is


Must read×

Top