Microsoft Access database rebuild
When the Access database still matters, but the business has outgrown the file.
I help rebuild important Microsoft Access systems as owned operational software when the database has become fragile, hard to share, hard to maintain or dependent on one person.
Problem diagnosis
The Access file is often holding more than data.
- Forms, queries, reports, macros and VBA contain business rules that nobody has clearly documented.
- The database locks, corrupts, slows down or behaves badly when several people need it.
- Remote access, permissions and reporting are being stretched beyond what the current setup handles safely.
The danger is interruption to a real process: order handling, records, scheduling, certificates, reporting or admin that the business still relies on.
Responsibility
A rebuild has to understand the old application, not just export the tables.
I start by mapping what the Access system actually does, then decide which parts should be rebuilt, migrated, simplified or retired.
What I would build
The first useful version would be concrete.
- 01
Database archaeology
Tables, forms, reports, queries, macros and user tasks are mapped into a readable picture of the current system.
- 02
A replacement data model
The records and relationships the business relies on are preserved in a cleaner structure.
- 03
Browser-based workflows
The core tasks can move away from shared-file access into controlled screens and permissions.
- 04
Reports and exports
Important reports are rebuilt around agreed definitions and checked against the old outputs.
- 05
Migration checks
Existing records are moved with validation around the fields, totals and history that matter.
Fit filter
Probably right, probably not.
Probably right when…
- Access runs a real business process.
- The original builder is unavailable or the logic is undocumented.
- You want a controlled replacement, not endless patching.
Probably not me when…
- You need same-day Access repair or VBA help.
- You want Access training, templates or query support.
- The database is personal, low consequence or still fits Access well.
First step
Start with diagnosis, not a big commitment.
The first step is to understand what the Access database does and where the business risk sits.
£150 per hour plus VAT where applicable. Two hours minimum for new clients. No retainer, no minimum term, no lock-in. You own everything I build.
Useful things to send before a call
- The Access file or a safe export
- Screenshots of forms and reports
- Known corruption, locking or remote-access problems
- Examples of business-critical records and reports
Objections
Questions this page should answer before you email.
Can you understand an undocumented Access database?
Often, but that discovery work is part of the job. Unknown logic must be surfaced before a rebuild depends on it.
Do we need to replace everything at once?
Usually not. The safest path is often to rebuild the riskiest or highest-value workflow first.
Can some Access reports stay for a while?
Yes, if that reduces risk. The migration path should serve the business, not a purity test.
Next step
If this looks like your problem, send me the awkward bits.
The useful first email is short: what is breaking, what product or process cannot handle it, and what working would need to mean.