Forum Discussion
Access web apps will be read only on April 1st, please plan accordingly
A year ago Microsoft announced that Access Service in SharePoint will be discontinued. We hope you've had a chance to migrate your app, but if you haven't here are some of the platforms you can recreate your application into:
- PowerApps - Web App
- Microsoft Access - a "regular" Access file that is not a web app
- Another web technology such as php or .Net
- Other platforms
Which technology you pick will depend on:
- Your IT department's guidelines on applications, some may prefer .Net or don't have any preference
- Your budget to re-architect the solution, some platforms, such as PowerApps, are easy to develop but are not as powerful, others such as .net are more powerful but much more expensive to develop, with Access in between the two
- Your time constraints: Given the short period between now and April 1st, you may need to put together an Access application instead of .Net just because it's faster.
What you should absolutely not do is wait, the time to act is now if you do have a mission critical access web application.
I have written a series of blog posts on rescuing your data from its Soon-To-Be-Late AWA. If you haven't yet figured out how you're going to do that with your data, right now would be a very good time to get that taken care of.
13 Replies
I have written a series of blog posts on rescuing your data from its Soon-To-Be-Late AWA. If you haven't yet figured out how you're going to do that with your data, right now would be a very good time to get that taken care of.
This claim really intrigues me as I've never heard anyone from Microsoft talk about doing anything like it.
"There are ways of automating conversion from AWA to Desktop Database apps."Are you claiming that you have a tool to
- Migrate data from the SQL Azure database to Access local tables (trivial in fact)
As well as
- Create new forms in an accdb which duplicate or replicate the AWA pages in layout AND function
- Recreate or migrate all queries
- Migrate macros and data macros in the accdb
If you can do that, and end up with a fully functional accdb complete with forms, queries, macros and, of course, tables, it would be interesting indeed. Of course, I'm referring only to the claim to have an automated way of doing it.
Thanks for supplying details.
Hi George,
PowerAccess and PowerGit provide fully automated conversion of the entire Access Web Databases (2010 Web Database format .accdb files) to Access Desktop Databases (.accdb files), complete with all objects, including Forms, Reports, Tables, Macros, and Data Macros.
We had successfully converted a massive Northwind Access Web Database sample, using PowerAccess and PowerGit, to a fully-functional, full-featured Access Desktop Database (supporting VBA, Design View, etc. unlike AWAs) without issue, within seconds, complete with all forms, reports, macros, tables (with structure and data converted from SharePoint Lists to local, Access DB-embedded tables) for example.
