Forum Discussion
Access web apps will be read only on April 1st, please plan accordingly
- Mar 18, 2018
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.
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.
- DanMoorehead_PowerWeb5AIMar 28, 2018Iron Contributor
Hi George,
Here is my previous post (which seems to have been deleted by moderators for some reason), which I have re-posted (together with edits for clarity) so that it's clear what you are responding to:
As George and Juan pointed out, it's critical to migrate away from Access Web Apps (AWA) and Access Web Databases now that they and Access Services for SharePoint have been deprecated by Microsoft. As Juan had mentioned, conversion to Access Desktop Databases (.accdb's) is one of the key methods for doing so, and can be combined with RDP/RemoteApp hosting for AWA-like web/cloud/mobile deployment. It's important to address this before the April 2, 2018 depreciation deadline when AWAs become read-only.
For those using earlier also Access Web Databases (Access 2010 format .accdb files for Web deployment), Access Web Database to Desktop Databases automated conversion may be the best option.
This is possible, for example, by using the new PowerAccess and PowerGit for Microsoft Access tools which, among other things, support automated conversion from Access Web Databases (2010 format Web Database .accdb) to full-featured Access Desktop Databases (.accdb).
PowerAccess, PowerSQL and PowerGit are new tools which modernize, automate and cloud-enable Microsoft Access through add-ins, framework and templates. One of the many new tools and features they provide is for fully automated conversion from Access Web Databases to full-featured Access Desktop Databases (.accdb files), including complete, automated conversion of all database objects (Forms, Reports, Tables, Queries, Macros, Data Macros, etc.).
You can then "cloud host" those desktop databases for streamed real-time use by hundreds of simultaneous users from mobile devices, PCs and web browsers - for use similar to your existing AWA or Access Web Database - as described further below.
One advantage that Access desktop databases provide is in enabling use of the full set of Microsoft Access development and automation tools (VBA, Design View, etc.). Though designed for multi-user use by hundreds of simultaneous users, they don't provide out-of-box provide support for web and mobile use, and are instead typically hosted on a file share (eg. via VPN).
That said, there are web & cloud deployment options for even Access Desktop Databases, such as Remote Desktop (RDP), especially with RemoteApp use (which streams just the window, not the desktop, and no need to launch the app, and scales up for many simultaneous users with the same host).
There are solutions for simplifying setup and cloud/streamed hosting of your Access databases like this. For example, PowerAccess has server setup tools and components which allow you host your Access desktop databases from any Windows PC (with or without Windows Server) to support hundreds of simultaneous users, and without requiring per-user licensing / CALs for various products.
There are also other options for RDP and RemoteApp deployment, as well as alternatives to Access Desktop Databases, such as completely redeveloping using PowerApps + Azure SQL or SQL Server, as both Juan and George had touched on.
Whatever approach you take, I agree with George that it's worth migrating away from Access Web Apps and Access Web Databases sooner rather than later, considering that these have now been deprecated and Access Services / Access Web Apps are going read-only on April 2, 2018.
Disclaimer:I had developed PowerAccess, PowerGit and PowerSQL as solutions to modernize and automate Microsoft Access with new database builder tools, framework, templates, and features.
Note to Moderators:
Please let me know if I need to make any further edits to this post (which I had previously rewritten to conform to described guidelines) instead of deleting again, if possible, as it specifically relates and provides answers to the thread topic (methods for converting/migrating away from Access Web Apps / Access Services for SharePoint before the deprecation deadline) and is being referenced in a discussion asking further details about it.- George_HepworthMar 28, 2018Silver Contributor
Your tool cal AUTOMATE conversion of AWA pages to an equivalent accdb based form, then?
So you take the html and automatically convert it into an Access form? That's pretty remarkable. Do you have a demo or sample one could see?
Thanks.
- DanMoorehead_PowerWeb5AIMar 28, 2018Iron Contributor
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.- DanMoorehead_PowerWeb5AIMar 28, 2018Iron Contributor
If interested in trying it out PowerAccess, PowerSQL or PowerGit for Microsoft Access as soon as possible, you can subscribe at:
www.PowerAccess.net
Then we will send out a notification once we make available for Early Access Program (EAP) users as well as later public release. You can find more info about PowerAccess, PowerSQL and PowerGit there as well. We will be releasing some videos, as well as screenshots of our new add-ins and more info about PowerGit later on as well.I look forward to getting feedback from you and others as soon as possible on what other new tools, automation features, and ways of avoiding boilerplate VBA coding you'd like to see next in PowerAccess and PowerGit =)
- George_HepworthMar 28, 2018Silver Contributor
Given the fact that AWA's do not even support reports, I find that a bit of a broad claim, but let that be for the moment.
So, your tool takes the html and JavaScript which generate browser pages from the tables where they are stored in SQL Azure and uses that to generate an equivalent Access object. COngratulations on that achievement.
- DanMoorehead_PowerWeb5AIMar 28, 2018Iron Contributor
PowerAccess | PowerGit convert Web Database .accdb files to Desktop Database .accdb files, enabling use of full Access features and preparing for RDP or other deployment.
I can provide you with zip of the database before and after conversion.
If you are interested in checking that out, just email me at Dan@PowerAccess.net.