skip to Main Content

SharePoint Online (and Server) support Access databases. More exactly, using Access Services users are able to upload a database in SharePoint sub-site, to work in it and to sync changes.

With this feature, people can publish Access 2010 databases to SharePoint and share them with others. The Access Services feature allows SharePoint Online users to view, create, edit, and save Access databases while working inside a web browser. Users can publish and share information across teams, and create and modify databases where no Access client is needed.

All you need is a web database (you can use a template or create your own) and a start-up form. Of course, you need to add data into the DB (form, query’s, etc.)

How to upload an Access database to SharePoint using Access Services ?

Still, there is a very big limitation: reports.

Access reporting is not supported by SharePoint Online Access Services because SQL Server Reporting Services (SSRS) is not currently enabled for SharePoint Online.  Access reporting requires SSRS.

Informations from Microsoft SharePoint Online for Enterprises Service Description.docx

Now, let’s see how to upload a DB into a SharePoint sub-site.

1. See if the DB is Web compatible: File Save & Publish – Publish to Access Services – Run Compatibility Checker.

How to upload an Access database to SharePoint using Access Services ?

If the database is not compatible, a new table will be created. In that table are shown all the incompatible elements: tables, query’s, reports, etc. Also, a solution and a link to a help page will be provided.

The current database is OK and I have no errors.

2. We must select a Web Display Form, because in SharePoint we won’t see the tables (you must create one before).

  • File – Options – Current Database and setup a Web Display Form.

How to upload an Access database to SharePoint using Access Services ?

Now, it’s time to publish the DB to SharePoint: File Save & PublishPublish to Access Service – fill in the Server URL and the Site Name and then click on Publish to Access Services.

How to upload an Access database to SharePoint using Access Services ?

In this moment, every object from the DB is published.

How to upload an Access database to SharePoint using Access Services ?

After the publishing operation is over, a link to the sub-site is displayed.

How to upload an Access database to SharePoint using Access Services ?

Here is the DB in SharePoint:

How to upload an Access database to SharePoint using Access Services ?

Now we can browse through the records, add new ones, search records, etc.
More than that a copy of the DB is created on the local machine during publishing.

From the Options menu we can choose to share this sub-site, open the DB in Access, or to view the DB components.

How to upload an Access database to SharePoint using Access Services ?

How to upload an Access database to SharePoint using Access Services ?

We also have two option to export a object to Excel, to modify it, to view it, etc.

How to upload an Access database to SharePoint using Access Services ?

If we want to edit the DB, we have to access the Modify this web database, add new fields, customize forms and reports link.

How to upload an Access database to SharePoint using Access Services ?

How to upload an Access database to SharePoint using Access Services ?

After we edit, add data, etc., we must sync the DB: File Info Sync All

How to upload an Access database to SharePoint using Access Services ?

 

Note:
It’s possible that from time to time (especially when you publish it), you will get a error message like the one from the bellow screenshot.
The solution is to close the DB and then re-open it.

How to upload an Access database to SharePoint using Access Services ?

(Visited 11 times, 1 visits today)

Cosmin Tătaru

Pasionat de blogging și tehnologie încă din 2009, Cosmin este aici să vă ajute să vă creșteți vânzările și productivitatea punând tehnologia la treabă pentru dumneavoastră.

Suport-Clienti
Mergeți sus