Case Studies
Legacy Modernization of a Decades-Old Microsoft Access Database and Banking Application
How Tevpro rebuilt a real estate firm’s Microsoft Access banking application, preserving financial logic while unifying Trust and Savings workflows.
Client Overview
A privately held, multi-generational real estate investment, development firm.
Challenge
A real estate developer relied on a 20-year-old Microsoft Access application for private banking and accounting. Replacing it meant preserving interest calculations, period-end controls, and the workflows behind Trust and Savings accounts.
Tevpro was selected to re-architect and modernize the company’s private banking platform into a secure, scalable, and cloud-ready web application built for the next generation.
The original application, developed in Microsoft Access, handled everything from internal accounting to private banking workflows. Over time, it became unstable, unsupported, and dangerously outdated.
Challenges of Legacy Software:
- No access to the original developers
- No design documentation available
- Disjointed databases for Savings and Trust accounts
- Manual reconciliation with duplicated data entry
- Limited access for remote work or multi-user collaboration
Interest calculations, period-end closings, and financial modeling were embedded in the old application. Those rules had to be identified and tested before the team could replace the interface and database.
Solution
Tevpro rebuilt the Access-based application as a web app. The work included tracing existing business rules, moving data into SQL Server, and rebuilding the workflows users depended on.
Reverse Engineering with a Purpose
With no technical documentation to start from, our development team reverse-engineered the system using a copy of the legacy database. From there, we:
- Rewrote custom VB code into TypeScript
- Re-architected Access tables into SQL Server
- Rebuilt queries, forms, and reports with a modern tech stack
The New Tech Stack
To ensure long-term scalability and support, Tevpro built the app using:
- TypeScript + Node.js
- NestJS for backend architecture
- Angular + Bootstrap for front-end UI
- Prisma ORM for efficient database access
- SQL Server as the core relational database
This modern stack supports cloud deployment, multi-device access, and agile updates.
Results
The new application brings Trust and Savings account data and workflows into one system. Users previously entered transactions in separate Microsoft Access databases; the new workflow reduces that duplication and provides shared records for accounting and reporting.
Key Benefits:
- Automated interest calculations with smart validation
- Locked-down accounting periods post month-end close
- Audit-friendly reporting and traceability
- Real-time collaboration for accounting and finance teams
- Less duplicate entry across Trust and Savings workflows
The new system supports interest validation, period-close controls, and reporting in one application. The result is a shared workflow for accounting and finance teams, rather than separate Access databases.
Is Your Legacy System Holding You Back?
For teams running critical workflows in Microsoft Access, the first decision is which business rules and data relationships must survive a rebuild. A short discovery phase can establish the scope before selecting a replacement architecture.
For help comparing retain, refactor, or rebuild options, see Tevpro’s legacy application modernization services.
Why work with us
Why Tevpro?
Whether you’re a startup with a bold product idea or an established company seeking a stronger delivery partner, Tevpro delivers results. Our expert consultants specialize in building secure, scalable applications that simplify operations and drive real ROI.
Client Testimonial
“Their team understood our processes, eliminated years of inefficiencies, and delivered a solution that will support us well into the future.”