MS Access Modernization & Migration Services

For when Access just isn’t cutting it anymore

Signs that it may be time to move away from Access:

Access is primarily meant for a single user or small user groups.  When  user counts start to reach 15-20 users, you may start to experience performance issues.

Access doesn’t have the record-locking complexity to handle larger user counts.  As your user count grows you may experience record locks causing users to be unable to access data or perform certain actions.

accdb or the older mdb files have a size limitation of 2GB.  If your database is approaching this size you may start to experience issues.

Access data files can experience data corruption issues from time to time.  These can often be resolved using the repair and compact tool.  However, if the corruption is occurring frequently, or if the repair tool isn’t fixing the issue, a more powerful database engine is recommended.

Many Access applications were created by a single employee.  If that person is no longer able to support the application, you many find the pool of qualified MS Access developers is shrinking as Access’s relevance in business applications wanes.

Access doesn’t provide the security or auditing capabilities of MS SQL or MySQL.

Modern users and customers expect remote access to their applications.  As a desktop application, Access doesn’t offer  remote access like a modern web application.

Access applications don’t provide modern REST API capabilities, limiting how efficiently they can be integrated with modern 3rd party applications.

Microsoft has “de prioritized” MS Access. As a result, its capabilities haven’t kept up with the times.  Access applications lack the modern user experience many users are used to with web applications.

How we can help

Initial Support and Remediation

If you’re experiencing issues that require immediate attention or need support for your application until it can be migrated we are able to support and deploy updates to address critical issues.

Requirements Gathering

User survey, walkthrough and/or shadow sessions as appropriate.

Application / Code Review

Including queries, forms, reports, macros and VBA code.

Project Estimate

Cost estimate, duration estimate, and approach plan, along with feature process enhancement recommendations.

Implementation

Phased redevelopment (Strangler Fig), database migration, QA, UAT and roll out.

Support

Ongoing support and enhancements as needed.

Access Modernization & Migration FAQ

We frequently experience data corruption.  Do we need to rewrite our entire application?

Not necessarily.  If your primary concern is data corruption, you may be able to migrate your database backend to a more powerful database platform like MS SQL to resolve the frequency corruption issues.

Is remote access to our Access application possible without migrating to a web application?

Yes, you can work with your MSP or IT department to configure remote desktop into a workstation running your MS Access application.  For security purposes this is usually accomplished with a VPN connection.  This will allow access to the application remotely, but introduces some extra steps compared to a web application and may provide slower performance.

Our Access application works fine.  We have no problems with it but our business depends on it.  Can’t we just continue to use what we have?

Yes you can. But you will want to periodically consider the risks and reevaluate if you want to migrate away from Access. Here are some things to consider:
1. Microsoft has “deprioritized” MS Access.  There is no scheduled sunset and Microsoft continues to maintain and incrementally enhance Access, but the platform’s fundamental desktop-oriented architecture has not kept pace with the requirements of modern, mission-critical business applications.
2. The pool of people qualified to support and develop in MS Access is shrinking as more developers focus on web application and native app development.
3. Your capabilities are limited and will continue to be as modern platforms evolve.

Can we just fix/enhance our Access Application rather than replace it?

Yes.  It is certainly possible to fix or continue to enhance your application within the boundaries of what Access is capable of if you can find qualified personal to do so.

Can our existing Access application continue running while the new system is developed?

Yes.  If the rebuild is planned properly.  We recommend this approach whenever possible because it provides a smoother transition to the new application, a backup plan if needed, and a validation tool to confirm the new application performs as needed.

Will we lose any of the functionality we have today?

Most likely no. Most web applications can deliver the same or better functionality. There are some features, like Interop, that are not available in web applications. If your system employs one of these office or desktop-specific features, a review of how to accomplish the desired functionality should be planned before replacement.

What if our Access application has little or no documentation?

Bottom line: Even if your Access application has little or no documentation, we can still successfully modernize it.
Lack of documentation is not a barrier to modernizing your Microsoft Access application. Documentation is just one of several tools we use to understand an application’s functionality.
Our discovery process combines user interviews, surveys, and hands-on shadowing sessions to understand how the application is used in day-to-day operations.
We also perform detailed developer code reviews, supplemented by AI-assisted code analysis when permitted, to uncover business logic, dependencies, and functionality that may not be immediately apparent.
Many Access applications were originally developed by individuals or business users without formal software development backgrounds. As a result, documentation may be incomplete, outdated, or inaccurate.
By combining technical analysis with insights from the people who use the application every day, we can reconstruct how the system works, identify opportunities for improvement, and build reliable documentation as part of the modernization process.

How do you minimize business disruption when replacing a mission-critical Access application?

Whenever possible, we favor a phased modernization strategy that combines the Strangler Fig Approach and parallel run. Rather than replacing the entire application at once, we modernize and deploy individual modules incrementally, allowing the new system to operate alongside the legacy Access application.
This approach minimizes disruption by introducing changes in manageable stages, making it easier to validate functionality, train users, and address issues before moving on to the next phase. It also allows employees to gradually adapt to the new system without having to learn an entirely new application overnight.
By maintaining the legacy application during the transition, we can also preserve a fallback option if unexpected issues arise.

Can you convert my Access database into a web application?

Yes. While there is no direct, one-click conversion of a Microsoft Access (.accdb or .mdb) application into a modern web application, we can redevelop your existing Access application as a fully functional, browser-based application.
Microsoft discontinued Access Web Apps in 2017 in favor of Power Apps.  Power Apps offer a modern web alternative for simple applications focused primarily on CRUD (Create, Read, Update and Delete) functionality, but can fall short for applications with complex business logic.  For applications with advanced business logic, modern full stack web technologies provide a much more powerful, flexible, and scalable replacement for MS Access.
We can replace your Access front end with an intuitive, modern web interface and migrate your data to a database platform such as Microsoft SQL Server. The new application can be hosted in the cloud or on-premises, depending on your requirements.
Throughout the modernization process, we use your existing Access application as a reference for understanding business processes, preserving critical functionality, and validating the new system.

Our Access application is linked to Excel spreadsheets. Can we migrate to a more modern application?

Yes.  We can evaluate the Excel spreadsheet, determine how it’s integrated into your Access application (e.g. Linked tables, InterOp, etc), and create a plan to either migrate the Excel data into a true database format or develop Excel integration using modern libraries.
As part of our discovery process, we evaluate how Excel is used within your existing application and determine the best approach for preserving or improving that functionality.

Pros and Cons of Access

Trying to decide whether or not it makes sense to switch from Access or not?

There are scenarios where it makes sense to stick with Access.

Check out this article: