The verdict in three sentences
An Access database from 2009 maintained by one person is an operational risk, not just an IT topic: file corruption, the expert leaving, incompatibility with Microsoft 365. A multi-user web app with access rights and automatic backups costs USD 16,500 to 50,000 and ships in 3 to 5 months. The project pays for itself once you honestly price one day of downtime and the time lost to workarounds.
What replacing an Access or VBA application costs
Price depends on the number of screens and reports, the complexity of rules hidden in macros, and the volume of data to migrate.
| Existing application profile | Example | Timeline | 2026 budget |
|---|---|---|---|
| Excel VBA workbook, 1 to 3 users | Quote calculator, simple stock tracking | 6 to 8 weeks | USD 9,000 to 16,500 |
| Simple Access database, 10 to 15 tables | Order and customer tracking | 2 to 3 months | USD 16,500 to 27,500 |
| Mid-size Access database, 20 to 40 tables, printed reports | Orders, production, invoicing | 3 to 4 months | USD 27,500 to 38,500 |
| Complex Access database, external links | Orders + accounting interface + EDI | 4 to 5 months | USD 38,500 to 50,000 |
| Several databases and workbooks to merge | Department silos | 5 to 7 months | USD 50,000 to 77,000 |
These amounts include analysis of existing macros, development, migration, testing and training. Hosting and maintenance come on top: USD 55 to 220 per month for Canadian hosting and 10 to 15% of the budget per year for ongoing improvements.
The real cost of doing nothing
An Access database above 1 to 1.5 GB slows down, corrupts more often and struggles with more than 5 to 10 simultaneous users on a network share. The risk calculation fits in a few lines.
| Risk | Estimated annual probability | Impact | Indicative cost |
|---|---|---|---|
| File corruption, restore from previous day | 20 to 40% | 1 day of downtime + re-entry | USD 6,500 to 11,000 |
| The only in-house developer leaves or is off long term | 10 to 20% | No more changes possible | USD 16,500+ for emergency takeover |
| Incompatibility after an Office update | 15 to 25% | Macros blocked for 2 to 5 days | USD 3,300 to 13,000 |
| Untracked data entry error | Frequent | Customer dispute, credit notes | USD 2,200 to 9,000 |
| No remote access | Permanent | Sales reps calling the office | 1 to 3 h per week per rep |
2026 ballpark: for a 45-employee company, cumulative risk often exceeds USD 11,000 per year, before counting time spent on workarounds.
The five-step migration plan
- Inventory (2 to 3 weeks): tables, queries, forms, reports, macros and unwritten rules, with interviews of key users.
- Design (2 weeks): new data model, roles (entry, approval, management), mockups of the main screens.
- Development in batches (6 to 12 weeks): delivery every two weeks to a test environment, users approve screen by screen.
- Migration of 15 years of data (2 to 3 weeks): duplicate cleanup, address normalization, totals checked before and after.
- Cutover and parallel run (1 to 2 weeks): the old database goes read-only, the team works in the new app with extra support.
Daily automatic backups, an audit log of who changed what, and secure smartphone access are part of the foundation at no significant extra cost.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Linda, operations manager at a 45-employee window manufacturer in Toronto, runs order tracking on an Access database built in 2009 by a colleague who retires in 8 months. The file is 1.8 GB and crashed twice last year. Cost of one day of downtime: 12 people blocked at USD 330 loaded per day, i.e. USD 3,960, plus about USD 5,500 in delayed orders, so USD 9,460 per incident. Quoted project: USD 35,200 over 4 months, plus USD 4,200 per year of maintenance and USD 130 per month of hosting. By avoiding two incidents a year and 4 weekly hours of workarounds (about USD 7,300), the annual gain reaches USD 26,200, for a payback of about 20 months.
FAQ
Can we keep Access as a front end with a SQL back end?
It is a possible interim step for USD 5,500 to 11,000, but it solves neither mobile access nor the dependency on Windows desktops. It only delays the decision by 2 to 3 years.
Will the 15 years of history be kept?
Yes. Migration carries over all useful data, with totals checked by year. Very old records can be archived as read-only.
Is a low-code tool like Power Apps cheaper?
Development may cost 20 to 30% less, but Premium licenses at about USD 20 per user per month exceed USD 10,000 per year for 45 staff.
How long do teams take to adapt?
With screens close to existing habits and 2 half-day training sessions, adoption usually takes 2 to 4 weeks.
Let's scope your project. We analyze your Access database or VBA macros, price the replacement between USD 16,500 and 50,000 and plan a no-downtime cutover within 3 to 5 months. 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.
