All posts
Legacy Modernization

The Access Database, the Excel Macro and the VB6 App Running Your Business: How to Replace Them

By

October 25, 2026

6 min read

Every company has one: an Access database on a file share, a macro-heavy spreadsheet or a VB6 desktop app that a critical process depends on. Why they are risky, how to replace them without breaking the people who rely on them, and when a low-code tool beats a custom build.

Microsoft Access
Excel
VB6
Legacy Modernization
Internal Tools

These tools were often the right choice when they were built. Someone close to the work solved a real problem quickly. Years later, the problem has grown and the tool has not: one person understands it, it runs on one machine, and it holds data nobody has backed up properly.

Why they become risky

  • A single owner. When that person leaves, the process stops or nobody dares change it.

  • No access control or audit trail. Anyone with the file can change anything, including the numbers finance reports.

  • Concurrency limits. Access databases on shared drives corrupt under multi-user load.

  • Platform drift. Office updates disable macros from the internet by default; VB6 components and 32-bit dependencies get harder to run on current Windows.

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Choosing what to build

If the tool is…

Replace it with

Mostly forms over a list, used by a team

A low-code platform your company already licenses (Power Apps, or similar)

A calculation or report someone runs monthly

A scheduled job and a dashboard, or a proper spreadsheet model with locked inputs

Core to operations, with business rules, integrations and many users

A small web application with a real database, authentication and an audit log

Only used by one person, rarely

Possibly nothing. Document it and leave it

How to replace one without breaking the process

  1. Sit with the people who use it and watch them work. The real requirements are in the workarounds, not the menus.

  2. Extract the data and the rules: tables, queries, macros and VBA. Rules hidden in VBA are the part most often missed.

  3. Build the replacement to do the same job first, with the same outputs, then improve it once people trust it.

  4. Run both in parallel for at least one full business cycle and compare outputs.

  5. Retire the old file by making it read-only, not by deleting it, for the first few months.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.