MS Access Database Modernisation | Migration to Azure SQL

If you're reading this, there's a good chance your business runs on an MS Access database that someone built ten or fifteen years ago. It worked brilliantly at the time. Five users, a few thousand records, everything on one server in the office.

Now you've got twenty people trying to use it simultaneously, the file is 1.5GB, and someone has to shout across the office "are you in the database?" before they can open it.

Sound familiar? You're not alone, and it's not your fault.

The Signs Your Access Database Is Holding You Back

I've had this conversation with dozens of business owners over the years. The symptoms are almost always the same:

• "Record locked by another user" — the error message that everyone in your office knows by heart
• Slow queries — reports that used to take seconds now take minutes, sometimes timing out entirely
• Corruption scares — the database crashes and someone has to run "Compact and Repair" while everyone holds their breath
• The single point of failure — only one person understands how the database works, and they're thinking about retiring
• No remote access — your team can't work from home because the database lives on a server in the back room
• Duplicate data everywhere — people have started keeping their own spreadsheets because the database is too painful to use

If you're nodding along to three or more of these, your business has outgrown Access. That's not a criticism — it means your business has grown, which is a good thing.

Why This Keeps Happening (It's Not Your Fault)

MS Access is a brilliant tool for what it was designed to do: small databases for a handful of users. Microsoft themselves say it's suitable for up to about 10–15 concurrent users. Push beyond that and you're fighting against the architecture, not just the software.

The core problem is that Access uses a file-based engine. Every user reads and writes to the same file on a shared drive. When ten people hit it at once, they're all fighting for access to the same physical file. That's why you get record locking, corruption, and the feeling that everything is held together with string.

A proper database engine like SQL Server or Azure SQL handles this completely differently. Each user gets their own connection. The engine manages concurrency properly. A hundred users can work simultaneously without anyone locking anyone else out.

The gap between "file on a shared drive" and "proper database engine" is the root cause of every Access headache you've ever had. Whether your team calls it Access database modernisation or modernization — the British and American spellings of the same problem — the fix is identical: move to a proper database engine and rebuild the application on top.

What Azure SQL Actually Is (In Plain English)

Azure SQL is Microsoft's cloud database service. In practical terms, it means:

• No server to maintain — Microsoft handles the hardware, updates, and backups. You don't need a server room or an IT person to babysit it.
• Accessible from anywhere — your team can work from the office, from home, or from a hotel in Spain. Same application, same data.
• Automatic backups — your data is backed up continuously. Not once a day, not when someone remembers. Continuously.
• Proper security — encrypted at rest and in transit, role-based access, audit logging. Not "the password is on a Post-it note on Dave's monitor".
• It scales — whether you have 10 users or 400, the database handles it. No more shouting across the office.

Running costs are typically £30–80 per month for an SME, which is less than most businesses spend on the IT call-outs caused by Access problems.

What a Migration Actually Looks Like

This is the bit that worries people most, so let me be upfront about how the process works — and how much it's changed recently.

The Traditional Approach

Historically, a migration meant weeks of painstaking manual work. A developer would sit down with your Access database and rebuild every table, every form, every query, every report by hand. Even a straightforward database could take two to three months from start to finish. Complex ones stretched longer. It was thorough, but it was slow and expensive — and that put bespoke software out of reach for a lot of smaller businesses.

How AI Has Changed the Game

AI-assisted development has cut that timeline by roughly 80%. That's not a guess — it's what I'm seeing on real projects, right now.

Here's what the process looks like today:

• Audit — I review your Access database with you: every table, query, form, and report. I map out how data flows through your business and find the hidden surprises — the VBA code behind buttons, the linked spreadsheets, the queries nobody documented but everyone relies on. This part is still human. It has to be.
• Design & Build — This is where AI makes the biggest difference. It analyses your existing database structure, generates the new schema, builds application forms, writes data validation, and creates test cases — all at a pace that simply wasn't possible two years ago. What used to be the longest and most expensive phase is now the fastest. I review and refine everything, but the heavy lifting that used to take weeks now takes days.
• Data Migration — Your data moves across with full validation. Every record is checked — row counts, totals, checksums. Nothing gets lost or mangled. You get a report showing exactly what was migrated.
• Parallel Running — The safety net. Your old Access database keeps running alongside the new system until your team is confident everything works. Only then do we switch off Access. I've never had a client need to go back.
• Training & Support — Your team gets hands-on training. I don't disappear after go-live — I'm there for questions, tweaks, and the inevitable "can we also do this?" requests that come up once people see what's possible.

The result is a faster, more cost-effective process that produces a more robust end product. AI doesn't get tired on a Friday afternoon, doesn't make typos, and catches edge cases that humans miss. You get enterprise-grade software — the same technology stack used by large companies — delivered in a fraction of the traditional time and cost.

The Bits That Catch People Out

I'd rather be upfront about these than have you discover them mid-project:

• VBA business logic — Access databases often have years of business rules buried in VBA code behind forms and reports. This logic needs to be identified and rebuilt properly. It's rarely documented, so the audit phase is critical.
• Private Access files — I've lost count of the number of times I've found team members with their own personal Access databases linked to the main one. These need to be accounted for.
• Reports — Access reports often look straightforward but contain complex grouping, calculated fields, and specific formatting that someone relies on. I make sure every report is accounted for and replicated.
• Data quality — after years of use, most Access databases have data quality issues: duplicate records, inconsistent formatting, orphaned records. The migration is a good opportunity to clean this up, but it takes time.

None of these are showstoppers. They're just things that need to be planned for rather than discovered halfway through.

How Long Does It Take and What Does It Cost?

This is where things have changed dramatically. Let me show you the before and after.

The Old Way (Pre-AI)

Traditionally, migrating an Access database meant a developer manually rebuilding every form, every query, every report from scratch. A straightforward migration could easily take 6–10 weeks. Complex ones stretched to months. The cost reflected that — bespoke software was genuinely expensive, and for many smaller businesses, it simply wasn't an option.

The New Way (AI-Assisted)

AI has cut delivery times by around 80%. That's not a marketing number — it's what I'm seeing on real projects, every day.

AI analyses your existing database structure, generates application code, builds forms, writes data migration scripts, and creates test cases — all in a fraction of the time it used to take. A migration that would have taken eight weeks now takes two. What used to be a three-month project can be done in a matter of weeks.

Crucially, the quality doesn't suffer. If anything, it's more robust — AI doesn't get tired on a Friday afternoon, doesn't make typos, and catches edge cases that humans miss. Every migration is validated, tested, and verified before you see it.

The result: faster delivery, lower cost, and a more reliable end product. Projects that were previously out of reach for smaller businesses are now very achievable.

Running costs are modest too — Azure SQL for a typical SME is £30–80 per month, which is less than most businesses spend on the IT call-outs caused by Access problems.

The best way to find out what it would look like for you? A quick chat. I'll be upfront about your specific situation, and if it doesn't make sense, I'll tell you that too.

What Your Team Will Notice After the Switch

The best feedback I get isn't about the technology. It's about the daily experience:

• "I can actually use it from home now" — remote working just works, no VPN fiddling required
• "It doesn't lock me out any more" — twenty people using it simultaneously without a single lock error
• "The reports are instant" — queries that took three minutes now take two seconds
• "I don't have to keep my own spreadsheet any more" — the system does what people need, so they stop working around it
• "I stopped worrying about it crashing" — proper backups, proper infrastructure, proper peace of mind

Is This the Right Move for Your Business?

Not every Access database needs migrating. If you've got five users, a few thousand records, and it works fine — leave it alone. Access is perfectly good at what it was designed for.

But if you're experiencing the symptoms I described at the top — record locking, corruption, slow performance, no remote access, growing pains — then yes, it's time to move.

A quick self-assessment:

• More than 10 concurrent users? Time to migrate.
• Database file over 500MB? Time to migrate.
• Corruption events more than once a year? Time to migrate.
• Team keeping separate spreadsheets? Time to migrate.
• Need remote access? Time to migrate.

If you'd like to talk it through — no obligation, no jargon, just a practical conversation about your situation — I'm happy to help. I've been doing this for over fifteen years and I genuinely enjoy helping businesses get past the Access ceiling.

Frequently Asked Questions

What is Access database modernisation?

Access database modernisation means replacing an MS Access database with a modern, scalable alternative — typically a proper database engine like Azure SQL or SQL Server, with a rebuilt application running on top. It preserves all your data, business logic, and workflows while removing the limitations of Access: record locking, corruption risk, single-file architecture, and no remote access. Modernisation is different from simply migrating data — it includes rebuilding the application and processes around a proper foundation.

How do I modernise an MS Access database?

The process has four stages: audit (mapping every table, query, form, report, and VBA business rule), design and build (rebuilding the application on Azure SQL using AI-assisted development), data migration (moving all records with full validation), and parallel running (old and new systems running side by side until your team is confident). AI-assisted development has cut this timeline by around 80% — a migration that would have taken eight weeks now typically takes two.

How much does Access database modernisation cost?

Most SME Access modernisation projects run £8,000–£25,000 depending on complexity — the number of tables, how much VBA business logic needs rebuilding, and whether custom reporting is required. AI-assisted development has reduced these costs significantly over the past two years. Azure SQL running costs are typically £30–80 per month after go-live, which is usually less than businesses spend on IT call-outs caused by Access problems.

How long does it take to modernise an Access database?

A straightforward Access modernisation — up to 20 tables, basic forms and reports, limited VBA — typically takes 2–4 weeks. A complex database with extensive business logic, linked spreadsheets, and custom reports takes 6–10 weeks. AI-assisted development has cut these timelines by around 80% compared to the traditional approach. You see working software from week one — real running code, not mockups.

What should I replace MS Access with?

Azure SQL is the most practical replacement for most SMEs — cloud-hosted, no server to maintain, automatic backups, accessible from anywhere, and fully supported by Microsoft. The application layer is typically rebuilt as a Windows desktop application in C# and .NET, which gives your team a familiar, fast interface. For businesses that need browser-based access, a web application is also an option. The right choice depends on your team size, working patterns, and existing infrastructure.

Can I modernise my Access database without losing data?

Yes. Data migration is fully validated — every record is checked with row counts, totals, and checksums before you go live. In 15+ years of Access modernisation projects, no client has lost data. The parallel running phase adds a further safety net: your old Access database keeps running alongside the new system until your team is confident everything is correct. Only then do you switch off Access.

What are the signs my Access database needs modernising?

The clearest signs: more than 10 concurrent users causing record locking; database file over 500MB and slowing down; corruption events requiring Compact and Repair; team members keeping their own spreadsheets because the database is too slow or unreliable; no remote access; only one person who understands how it works. If you're experiencing three or more of these, the cost of staying on Access exceeds the cost of modernising.

What is the difference between migrating and modernising an Access database?

Migration typically refers to moving data from one database to another — just the data. Modernisation is broader: it means rebuilding the entire system on a modern foundation, including the application, forms, reports, business logic, and data. A migration without modernisation often produces a legacy system on new infrastructure. Full modernisation produces a system built for how your business actually works today, with the capacity to grow.

What technology is used to replace an MS Access database?

The replacement is built on Microsoft's .NET stack — a C# application with an Azure SQL cloud database. Desktop interfaces use WPF; web-accessible versions use ASP.NET Core. Azure SQL gives you automatic backups, remote access from anywhere, and proper multi-user concurrency — the core limitations Access was never designed to overcome. All source code is version-controlled in GitHub and owned outright by the client.

How do I get started with an Access database modernisation project?

The first step is a conversation — describe your current Access database, the problems you're experiencing, and roughly how many users and records are involved. You'll get an honest assessment of the scope, a realistic cost range, and a clear picture of the process. If it makes sense to proceed, the next step is a short audit session to map the database before any development begins. Get in touch to start the conversation.