In this article users are explained about the upcoming web app and web database shutdown in MS Access, along with listing solutions for the same.
Microsoft has announced that from June this year, it will end the creation of Access web Apps, along with Access web databases, for both Office 365, and SharePoint online. By April next year, all the existing web apps and web databases would be shutdown. This decision however, does not impact the desktop databases in Access, as they are powerful with certain features, which makes them ideal for business solution. So if you are one of those users looking for a solution to deal with this problem, you have reached the right place. Given below is a list of alternatives that you can try out.
Instead of using Access web apps or web databases, you can opt for using MS PowerApps as a business solution, especially if you do not wish to make use of codes. Comparatively new, MS PowerApps, can provide a reliable solution for web as well as mobile devices. With MS consistently making investments in this product, it will gradually become one of the premiere tools with regularly added new features.
Migrating Data from Access Web Apps
Migrating data stored in Access web app to other data sources is another reliable solution you can opt for. Given below are a few different ways using which you can migrate data.
- SharePoint – Use ‘Export to SharePoint List’ option for exporting data to the same. This option will be available to you in the Access web app browser. When you are done exporting data to SharePoint List, you will find a list created for each exported table. This list will contain the data exported from the web apps.
- Access Desktop Database – Another location you can export data to is the Access desktop database. By exporting to desktop databases, you will convert Access web app tables to local tables, for this you will need connection information for all Access web app tables.
- SQL Server – To be able to migrate data from Access web apps to SQL Server, you will first have to move it to Access desktop database, and then move the database to SQL Server. Once you have migrated data to SQL Server, you might also import or link to other SQL Server databases on Access desktop database. You can directly migrate data from the backend of Access web app to SQL Server, using SQL Azure Migration Wizard.
Take the Following Actions as an Admin
If you are the admin of the Access database, you can prevent new Access web apps from being created, by selecting the ‘Do not allow users to create new apps’ from the SharePoint Admin center. This will prevent the creation of new apps, but will allow the old apps to continue existing. Also in case you have corrupted mdb databases which contain data from web apps, try to fix them at the earliest.
As an admin you also have the ability to scan the Access environment for all the existing web apps, as well as web databases. Make use of a scanning tool for the same, and you will get an inventory list to understand what all web databases and web apps need migration.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupted mdf and excel recovery software products. For more information visit www.datanumen.com