We no longer recommend using Access 2010 and Access Services for new Access web databases.
-
This feature is retired from Microsoft 365 and SharePoint Online. You can no longer edit an Access web database. Microsoft plans to remove the 2010 Web Application Service from Microsoft 365 and SharePoint Online in March 2020.
-
In SharePoint Server this feature will be supported in accordance with the Microsoft Lifecycle Policy.
Access Desktop databases (.accdb) are not impacted by this decision. Desktop databases have powerful features that make Access a popular way to create business solutions. We will continue to invest in Access Desktop databases by expanding data connectivity, database management, and other features.
Consider using PowerApps
As an alternative to Access web databases, we recommend that you consider Microsoft PowerApps to build no-code business solutions for the web and mobile devices. Although PowerApps is a relatively new product, Microsoft is making a significant investment in PowerApps to make it a premiere tool for business solutions, and is adding new features on a regular basis.
Note: PowerApps is not yet available in Office 365 operated by 21Vianet or Office 365 Germany.
Ways to migrate Access web database data
There are two ways to migrate your data.
Export the SharePoint lists to Excel
Access web database data is stored in SharePoint lists. You can display the SharePoint lists, and then export them to Excel.
-
In Access, select File > Options.
-
In the Access Options dialog box, click Current Database.
-
Under Application Options, clear Web Display Form.
-
Open the web database.
-
Select File > Info.
-
In the Sync All section, under Access this database on the Web, click the URL.
-
On the SharePoint site page, under Tables, click the drop down arrow, and select Export to Excel.
-
In the browser, select Save, and then select Open.
-
In Excel, save the file.
Unpublish the web database
When you unpublish the web database, all the data becomes available in a local Access database.
-
Open the web database using Access desktop.
-
Select File > Save As > Save Database As > Save As Local Database.
-
Enter a new file name.
-
Select Save.
