Microsoft Ignite 2018 recap: Access team showcases new data visualization features

Microsoft Access is a natural extension from Excel and gives the business user the ability to develop quick work-group solutions at low cost. It's basically free and already installed on many corporate computers so it's accessible by business thought leaders. There will always be these types of business user friendly tools available.

After years of accumulating technical debt, these simple MS Access database applications (which are working prototypes of potential enterprise IT solutions) become brittle and unable to continue to scale.  These immature legacy systems require senior IT professions to re-architecture to remain effective.  (Sorry, there is no silver bullet).

Each instance is different, like each patient entering a hospital is different.  The general protocol for nurturing and maturing a corrupting MS Access system is similar across all cases (think common cold) but each individual instance is different and requires a careful examination of the business requirements in order to prescribe the best individual treatment plan.

Not all MS Access systems deserve to be invested in to promote to more modern version. 

In large organizations, Microsoft Access fills a gap between IT Enterprise systems. When developing a risk mitigation plan, you must examine the target solution from the business, data, application and technical prospective.  Often the first step is performing either a discover across the client's network to build an IT asset inventory.  After further investigation, the best candidates (highest business risk) can be identified and then further examined to customize the treatment plan.

In general, if you have a simple MS Access database application, then migration path is simple. 

If you have 65,000 MS Access databases like Safeway/Albertson, then the path forward is much more complex because your treating an epidemic of instances and not a single instance.  https://www.help4access.com/ms-access-risk-mitigation-pt1/

My hope here, is to elevate the discussion from a pure technical discussion to a more holistic approach.

If you would a private consultation, please book an appointment here:  https://www.help4access.com/schedule/

Kind regards,

Sasha Froyland - President / Enterprise Architect

http://www.Help4Access.com