Flux Dynamics/Work/Access Rescue

Off Access, nothing lost

Type Blueprint
Area Legacy Replacement
For Small firms and large organisations
Overview

Plenty of UK businesses run on an Access database or a spreadsheet full of macros that someone built years ago. It works, so nobody touches it. The person who understood it may have left.

Microsoft ended support for Office 2021, which includes Access, on 13 October 2026, with no extension. A database that was a key-person risk is now a security risk too.

This blueprint moves it to a secure web app without losing what it does. AI reads the old tables, forms, queries and macros and writes down what each one does in plain English. That becomes the specification. We rebuild against it, run old and new side by side, and switch over when the numbers match.

This is a blueprint, not a client case study. It draws on our work replacing end-of-life platforms.

Replaces
Access databases and macro-driven spreadsheets
Works with
Your existing data, moved across with its history
Draws on
Platform replacement and data engineering work
Explained
Every table, form and macro in plain English
Parallel
Old and new run side by side before switch-over
Secure
Proper logins, permissions and backups
Kept
Your records and history come across
The problem

It works, until it doesn't

These systems fail in ordinary ways. An update breaks a macro. Two people open the file at once and one set of changes is lost. The one person who knows the queries goes on holiday in the busy month.

Unsupported software adds a security risk on top, because the security fixes have stopped.

How it works

Four steps, a person in charge

Reads the old system

AI goes through a copy of the database and documents every table, form, query and macro, including the ones nobody remembers.

Agrees the spec with you

You get a plain-English description of what your system actually does, and you correct it. That document is the brief.

Rebuilds it properly

A hosted web app with logins, permissions, an audit trail and backups, built to do what the old one did.

Runs in parallel

The same inputs go through both systems until the outputs match. Only then do you switch.

Where it fits

Same pattern, any size

For a small firm: Job tracking, quoting, stock or membership databases that the business depends on and nobody wants to touch.

For a larger organisation: Departmental tools that grew up outside IT, often in finance and operations, now sitting on an unsupported desktop install.

How we would start

On your data, first

We start by pointing the AI at a copy of your database and returning the plain-English description of what it does. That document is useful on its own, and it tells us both how big the rebuild is.

Book a call

Sources: Microsoft: end of support for Office 2021

Next blueprint
Answers From Your Documents
View blueprint