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.