I work at a managed service provider (MSP), and we have a client still using an outdated, on-premises Access-based program. This software is notorious for database instability, with tables getting corrupted weekly. The situation is complicated by the fact that the software only runs on Windows Server 2012 R2, and updating it isn't an option because the newer version won't work. The single virtual machine (VM) running this software struggles under peak hours, with 30 remote desktop sessions operating simultaneously. I've explored cloud solutions but found them too costly given that this server needs to run 24/7 with no downtime. When the VM crashes, it leads to chaos. I'm looking for availability solutions, either on-premises or temporary cloud options, but I'm unsure where to start. Any ideas would be appreciated! Thanks!
5 Answers
Sounds like this solution really needs a major overhaul. Sure, it’ll cost money, but you should outline the potential losses from constant outages. This can show the client how crucial it is to invest in a modern solution, whether it’s finding a SaaS option or building a new application altogether.
Yeah, without updates, their situation is just going to deteriorate further.
To be honest, you might want to compile a list of all the issues related to this software and link them to business risks. They probably think keeping you on is cheaper, but if you’re available 24/7 to fix issues, that adds up. Do they even know how much those disruptions cost them?
Great point! You also need to clarify any contractual obligations and what happens if the situation spirals out of control.
Absolutely! If they don’t agree to a real migration, you should consider ending the partnership.
If firing the client isn't an option, think about setting up a VM cluster. It might help with both capacity and availability. Just a heads-up, though, this won't patch the database corruption problem you’re facing with Access in the long run.
Exactly! Migrating off Access is really the only permanent fix.
They already had major issues before. It's a ticking time bomb waiting to go off!
I've had clients in similar predicaments before. Instead of ditching them, I found a developer through Upwork to switch their app from Access to SQL Express for about $500. It greatly improved stability, and my client started recommending me to others!
Have you considered migrating the database to SQL? It generally offers much better stability than Access. You could start with generating a report to identify what can't be converted—who knows, maybe you’ll get lucky!
Definitely a wise first step! You'll want to see what's feasible for conversion before jumping in.
That's true! If they can't afford a big project now, maybe show them a simple app that uses fewer resources to reduce costs.