Legacy business systems support

An older database or spreadsheet acting up?
Let’s take a look.

An old Access form, an Excel macro, a missing report, or a SQL import that suddenly fails can bring work to a stop. I help find the cause, make sensible repairs, and improve what you already have.

Talk about your system

What I work with

Practical fixes for familiar tools.

01 / Main specialty

Legacy Business Systems

Keep the tools your team already knows working, and improve them where it makes sense.

  • Microsoft Access forms, queries, reports and database repairs
  • VBA macros and older Office-based applications
  • SQL Server, SSIS, SSRS and Microsoft Dynamics GP reporting
  • Troubleshooting, documentation and careful upgrades
02 / Everyday tools

Spreadsheets & Automation

Fix recurring spreadsheet problems and make reports easier to maintain.

  • Excel formulas, Power Query, VBA and workbook cleanup
  • Google Sheets formulas, reporting and CSV imports
  • Controlled data transfers between spreadsheets and older systems
  • Google Apps Script automation by agreed project scope
03 / Ongoing help

Bookkeeping & Part-Time Operations

Help with ongoing work without adding another full-time position.

  • QuickBooks Online and reconciliations
  • Accounts payable, receivable and business records
  • Administrative coordination and document preparation
  • Recurring reporting and fractional support

Microsoft Access & VBA

That Access database doesn't have to be a mystery.

Maybe your business has used it for years and the person who wrote it is gone. I can look at the forms, queries, VBA and linked data to understand how it works before making changes.

For Office version changes or 32-bit to 64-bit issues, the first step is checking references, API declarations and dependencies. Some older components may need replacement rather than a quick code edit.

Common requests

  • Fix forms, queries and reports
  • Trace VBA errors and broken references
  • Review multi-user performance and file structure
  • Connect Access to SQL Server when appropriate
  • Document undocumented applications

Demonstration data is fictional and is provided to illustrate the workflow.

See a related project demonstration →

Excel & Google Sheets

Spend less time fighting the spreadsheet.

From broken formulas and macros to reports that take hours to refresh, I can help untangle the workbook and make the process easier to maintain. Google Sheets can be useful for sharing selected data and simpler workflows, but not every Excel macro has a direct equivalent.

Typical work

  • Repair formulas and VBA macros
  • Improve slow or repetitive workbooks
  • Power Query and recurring imports
  • Google Sheets formulas and reporting
  • Review whether Apps Script is the right fit before quoting custom automation

Demonstration data is fictional and is provided to illustrate the workflow.

See a related project demonstration →

SQL Server, SSRS & Dynamics GP

Reports and queries that people can depend on.

I've spent years maintaining SQL Server systems and building financial and operational reports. My Dynamics GP experience includes more than 100 SSRS reports. That background helps when an existing report needs to be corrected, updated, or made easier to run.

Technical support

  • T-SQL queries and stored procedures
  • SSRS reports and scheduled reporting
  • Dynamics GP SQL-based reporting
  • Database troubleshooting and performance review
  • Data extracts, reconciliation checks and documentation

Demonstration data is fictional and is provided to illustrate the workflow.

See a related project demonstration →

Imports & older integrations

Make the data flow without all the manual copying.

When an application exports CSV files, sends data through an API, or feeds an accounting system, the challenge is often getting reliable data into the right place. I've worked with scheduled imports, SSIS workflows and API-to-SQL integrations.

Examples of established experience

Scheduled API pulls into SQL Server, with ID-based matching to insert and update records.

Workforce and other source data integrated into Dynamics GP reporting and processing workflows.

Each integration needs a review of source access, security, data quality, and how errors should be handled.

Demonstration data is fictional and is provided to illustrate the workflow.

See a related project demonstration →

Modernize without starting over

Keep what works. Change what needs changing.

Not every older system needs replacing. Sometimes a backup, a documented workflow, a fixed import, or a better report solves the immediate problem. If replacement really is the better choice, we can plan it in manageable steps.

A careful approach

  1. Understand how the current system is used.
  2. Identify risks, dependencies and backups.
  3. Fix the immediate issue and test it safely.
  4. Recommend the next improvement only if it adds value.

Demonstration data is fictional and is provided to illustrate the workflow.

See a related project demonstration →

Start with the problem in front of you.

An Access form has stopped saving records. A VBA macro needs attention. A report doesn't match the books. Or you have years of spreadsheet history and need a safer way to share the results.

I start by understanding what the system does, who depends on it and what happens when it fails. Then we can decide whether to repair it, document it, simplify the workflow or plan a careful change.

Examples of the work

  • Diagnose a broken Access form, query or report.
  • Repair Excel VBA macros and repetitive workbooks.
  • Improve recurring SSRS reports and SQL data extracts.
  • Move selected reporting data into Google Sheets through controlled exports.
  • Document older workflows so they are easier to maintain.

These are examples of available services, not claims about specific completed client projects.

Relevant experience

Old and new can work together.

My background includes SQL Server, Microsoft Dynamics GP, more than 100 GP SSRS reports, data integrations, Excel automation and business applications. When an older tool needs a modern output, the goal is a reliable connection—not change for change's sake.

Google Sheets, Excel and Access can each be useful. The right choice depends on your data, security needs, users and existing workflow.

Need help with the ongoing work too?

When simple automation is not enough

Practical AI-assisted workflows

For suitable tasks, a small AI-assisted tool can help organize incoming requests, search approved information, or draft material for human review. The goal is a useful workflow—not AI added for its own sake.

Explore AI-assisted business tools →

Keep people in control

We can start with a manual process, decide what can be automated safely, and retain human review for important decisions.

Tell me what your system is doing.

A short description of the problem and the tool involved is a good place to start. We can agree on a practical first step.

Discuss your project