Forum Discussion
Access web apps will be read only on April 1st, please plan accordingly
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.
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.
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 mailto:Dan@PowerAccess.net.
Wait a second.
"PowerAccess | PowerGit convert Web Database .accdb files to Desktop Database .accdb "
Perhaps you mistyped there. An Access Web App is not in an accdb file. So perhaps you meant to type accdw? Or perhaps you're talking about something else?
If interested in trying it out https://www.PowerAccess.net/MicrosoftAccess-ExcelQuery-Database as soon as possible, you can subscribe at:
https://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 =)