Microsoft has announced they are killing the Access Services within SharePoint Online in March 2018.
There are several ways to get data out of the system (below).
- Export Access web app tables to an Access desktop database - This works as a means of exporting data for import into another database engine or solution.
- Convert Access Web App tables to SharePoint Lists - This may work depending on the size of your database, but without being able to tie SharePoint lists together, it's not a database.
However, Microsoft has recommended the replacement be a PowerApps implementation. I spent the afternoon yesterday looking into this and I do not see how this is really a feasible solution without a significant amount of work and data migration, and even then it won't match the capability of AWA with the amount of data in the system. I've also reviewed the Introduction to Microsoft PowerApps for Access web apps developers (DOCX Download) -- it most likely will not fill the void that AWA will leave.
Has anybody else looked into this, or come up with a solution to address this end of life notice?