The verdict in three sentences
An Access or Excel VBA database maintained by a single employee is a total-loss risk the day that person leaves, gets sick or the Windows machine dies. Migrating to a custom web application costs, as a 2026 order of magnitude, between 20,000 and 60,000 USD in Miami, over 3 to 5 months, data migration included. The budget is driven by the quality of historical data and the number of screens, not by the technology stack.
Why a 2008 Access database becomes a business risk
The office manager of a Miami distribution or services SMB knows the picture: an .accdb file on a shared drive, VBA macros written by someone who left years ago, forms that crash with 64-bit Microsoft 365. Typical symptoms: one writer at a time, no record of who changed what, manual backups on a USB stick, and no access from the Fort Lauderdale branch or from home.
The real danger is human. When the only person who understands the queries leaves, the company loses the ability to invoice, track stock or manage contracts. A web application centralizes data in a hosted PostgreSQL database, manages role-based permissions, logs every change and backs itself up every night.
| Criterion | Current Access or Excel VBA | Custom web application |
|---|---|---|
| Concurrent users | 1 to 5, frequent conflicts | 50+ without conflict |
| Multi-site and remote access | Fragile VPN or impossible | Browser, HTTPS |
| Backups | Manual, often forgotten | Automatic daily, 30-day retention |
| Change traceability | None | Log per user and date |
| Dependence on one person | Total | Documented, transferable code |
| Privacy compliance (CCPA-style, HIPAA if relevant) | Hard to demonstrate | Permissions, purge and export built in |
| Annual upkeep | Hidden (employee time) | 15 to 20% of build in maintenance |
What the migration costs in Miami in 2026
Price depends on four factors: the number of tables and forms, the complexity of VBA macros to rewrite, the volume and cleanliness of historical data, and integrations (QuickBooks, email, Excel export). A competent team always starts with a 3 to 5 day audit listing tables, queries, printed reports and business rules hidden in the code.
| Database profile | Typical scope | 2026 budget | Timeline |
|---|---|---|---|
| Small Excel VBA workbook | 5 to 10 sheets, 1 process | 20,000 to 28,000 USD | 2 to 3 months |
| Standard Access database | 15 to 30 tables, 20 forms | 28,000 to 42,000 USD | 3 to 4 months |
| Complex Access database | 40+ tables, heavy VBA, reports | 42,000 to 60,000 USD | 4 to 5 months |
| Initial audit and mapping | Inventory and fixed quote | 3,000 to 6,000 USD | 1 week |
| 10 to 20 years of data migration | Cleaning, deduplication, checks | 4,000 to 10,000 USD | 2 to 4 weeks |
| US hosting and backups | Managed server, PostgreSQL | 80 to 300 USD per month | Ongoing |
Data migration is the most underestimated line. Twenty years of manual entry produce duplicate customers, dates stored as text and repurposed fields. Plan a full dry run on a copy, then a Friday-night cutover with a 24 to 48 hour data-entry freeze.
The five-step method
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Audit and scope freeze: inventory of tables, macros and real usage; often 30% of screens are no longer used.
- Clean data model: foreign keys, constraints and history tracking, which Access handled poorly.
- Development in batches: the most-used module first, tested by key users every two weeks.
- Dry run then live migration: replayable migration scripts, anomaly report, reconciled totals.
- Training and parallel run: two to four weeks with the old database kept read-only.
Mini case study
Maria, office manager of a 28-person medical supplies distributor in Miami with 2 sites, depends on a 34-table Access database. The employee who maintains it spends about 6 hours a week on fixes and exports: 6 x 45 weeks x 52 USD loaded = 14,040 USD per year. Re-keying between sites costs another 4 hours a week for two assistants, about 9,400 USD per year. The project, quoted at 39,000 USD, plus 3,500 USD of yearly maintenance and hosting, pays back in a little under two years on time savings alone, before counting the avoided risk of an invoicing outage.
FAQ
Can we keep Excel for some uses? Yes, the web app can export to .xlsx in one click and import template files. About 80% of clients keep Excel for ad hoc analysis, but no longer for data entry.
How long is data entry frozen during cutover? Usually 24 to 48 hours, scheduled over a weekend. Migration scripts are tested at least twice on a copy before go-live.
What happens to Access printed reports? They are rebuilt as server-generated PDFs, often 10 to 20 templates. Budget 400 to 1,000 USD per complex report.
Will I own the code? You should: require an IP assignment and the code in a Git repository under your company's name. It is the best protection against a new single-person dependency.
Wouldn't a no-code tool be enough? For fewer than 10 tables and 5 users, sometimes. Beyond that, subscriptions at 20 to 45 USD per user per month and business-logic limits make custom software cheaper over 3 years.
Let's scope your project. Send us your database or a screenshot of its tables and we will price the audit, the data migration and the full rebuild with a firm delivery date. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
