Case Study

Legacy Management System Replacement for a Manufacturing Business in Leeds

The problem

Their legacy management system, hosted on an ageing Microsoft SQL database with a Microsoft Access front end, had been patched so many times it was barely extensible; searches with no pagination meant performance kept degrading as the database grew, and even routine tasks like handling tax years needed manual developer intervention.

Project overview

Our client, a Leeds-based manufacturing business with around 50 employees, had been battling against an ageing legacy system that was well past its prime. The company, split across sales, office support, contracts, and factory staff, was struggling with a system that had become slow, cumbersome, and borderline unusable.

Their old management system, built by a now-defunct company, had been patched so many times that extending or modifying it was a near-impossible task. Performance was dragging, basic tasks had become frustratingly slow, and even something as critical as handling tax years required manual developer intervention. It was clear: they needed a fresh start.

Since implementing the new system, we’ve already seen a huge improvement in speed and flexibility. Searching for jobs is much faster, and being able to access everything remotely has made a big difference. We’re excited about the productivity gains ahead! – Sophie Langdale, Managing Director

Challenges and limitations

The core problem: their system was outdated, inefficient, and holding them back.

Performance issues
Searching for records meant pulling every result with no pagination, so as the database grew, performance kept getting worse.

Rigid structure
No general ledger functionality and manual tax handling meant extra workarounds.

End-of-life technology
Hosted on an ageing Microsoft SQL database and accessed via an old version of Microsoft Access.

On-premise hassles
Managing an outdated server added to their IT support burden.

Development bottlenecks
Even small changes required coding, making adaptability nearly impossible.

Solution implementation

We proposed a complete overhaul: a modern online platform, accessible from any device via a web browser, removing the dependency on legacy desktop applications. The new system is cloud-based, for easier remote access and long-term scalability.

Results and business impact

The implementation of the new system brought immediate improvements across key areas:

Speed & performance: Optimised workflows and simplified queries significantly boosted system responsiveness.

Ease of use: Employees adapted quickly, with processes feeling intuitive rather than cumbersome.

Remote access: Sales teams and office staff can now work from anywhere, reducing reliance on on-premise infrastructure.

Scalability: Future modifications are simpler, so the system can evolve alongside the business.

Beyond the initial success, our commitment continues with ongoing support: we’re on-site every two weeks, gathering feedback, providing training, and refining features to improve long-term efficiency.

Why this matters

For any manufacturing business stuck in a cycle of patching and maintaining outdated software, this case study is proof that a modern, cloud-based approach isn’t just a luxury. It’s a necessity.

This project wasn’t just about swapping out an old system. It was about giving a business the tools it needs to grow. If your company is dealing with similar legacy system frustrations, let’s talk about how we can help.

Results

Migrated 18 years of legacy data to the new cloud platform. Ongoing support continues on-site every two weeks.

Book a discovery call