The verdict in three sentences
Replacing a legacy Microsoft Access database built 15 years ago with a custom web application costs a Toronto mid-market company 30,000 to 100,000 CAD in 2026, plus 4,500 to 15,000 CAD for data migration and 75 to 450 CAD per month of hosting. The main risk is the loss of business knowledge buried in queries, macros and forms nobody ever documented. A phased migration over 3 to 6 months, module by module, contains that risk and avoids a hard cutover that would stall accounting or logistics.
Why an Access database becomes a CFO-level risk
Many Ontario mid-market firms still run a critical tool on Access: order tracking, commission calculations, contract management, reporting. It works, but it often depends on one shared file, a former employee who left and a PC that must never be updated.
| Warning sign | Concrete consequence | Risk level |
|---|---|---|
| Database author has left the company | Nobody can change the VBA macros | High |
| .accdb file shared on the network | Corruption under concurrent access, 2 GB limit | High |
| No access outside the office | No remote work, no mobile use | Medium |
| No granular permissions | Every user sees sensitive data, a PIPEDA concern | High |
| Manual Excel exports for reporting | 5 to 15 hours a month of rework | Medium |
| Tied to one Office version | Breaks during a Microsoft 365 move or new PC rollout | Medium |
The day the file corrupts during month-end close, the cost of downtime often exceeds the cost of migration.
What the web rewrite costs
The budget depends mainly on the number of tables, forms and calculation rules hidden in VBA. A 3 to 5 day audit inventories them before pricing.
| Item | 2026 order of magnitude (CAD) | What moves the price |
|---|---|---|
| Audit and business rule mapping | 3,500 to 9,000 | Number of macros, queries and reports |
| Screen and workflow design | 4,500 to 12,000 | Number of user profiles |
| Web application development | 18,000 to 65,000 | 10 to 60 tables, calculation complexity |
| Data migration and cleansing | 4,500 to 15,000 | Duplicates, free-text fields, 15 years of history |
| Business testing alongside the old tool | 2,000 to 7,500 | Number of cases to validate |
| Training and documentation | 1,500 to 4,500 | Number of users and sites |
| Hosting (Canada) | 75 to 450 per month | Volume, backups, high availability |
| Ongoing support and enhancements | 450 to 1,800 per month | How often changes are requested |
These are 2026 orders of magnitude for the Toronto market. A 15-table database with a few reports lands around 30,000 to 45,000 CAD. A 50-table tool calculating bonuses, inventory and margins approaches 85,000 to 100,000 CAD.
Phased migration rather than big bang
Rewriting everything at once and switching over on a Monday morning is the riskiest approach. A phased migration runs both systems side by side while each module is validated.
| Phase | Duration | Deliverable | Risk controlled |
|---|---|---|---|
| 1. Audit and rule extraction | 2 to 4 weeks | Map of tables, macros and calculations | Loss of business knowledge |
| 2. Central database | 2 to 3 weeks | Data moved to PostgreSQL or SQL Server | Access file corruption |
| 3. First web module | 3 to 6 weeks | Most-used module in production | User rejection |
| 4. Remaining modules | 4 to 10 weeks | One module every 2 to 3 weeks | Business interruption |
| 5. Access shutdown | 1 to 2 weeks | Read-only archive | No way back |
A useful trick: during phase 2, Access can temporarily act as a front end on the new central database. Users keep their screens while the web modules arrive.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mark, CFO of an electrical equipment distributor in Mississauga (illustrative example), relies on a 35-table Access database that calculates commissions for 40 sales reps. The accepted quote: audit 6,500 CAD, development 55,000 CAD, data migration 9,500 CAD, testing and training 6,000 CAD, or 77,000 CAD, plus 220 CAD a month of hosting and 900 CAD a month of support.
His maths: the financial controller now spends 12 hours a month cleaning exports and 2 days a quarter fixing disputed commissions. The web app removes most of that work, about 190 hours a year, or roughly 13,300 CAD at 70 CAD per loaded hour. The bigger gain is continuity: three days of downtime during commission payroll would cost far more.
FAQ
How much does an Access to web migration cost in 2026?
Plan 30,000 to 100,000 CAD for the rewrite, plus 4,500 to 15,000 CAD of data migration. The number of tables and VBA rules is the main price driver.
Can we keep all historical data?
Yes, in the vast majority of cases, after cleaning duplicates and inconsistent fields. This step often accounts for 10 to 15% of the total budget.
How long does a phased migration take?
3 to 6 months for a mid-market company, with a first module live after 6 to 10 weeks. Access stays available read-only at the end.
Should we use Power Apps instead of a custom build?
Power Apps suits simple needs if you are already on Microsoft 365, with licences of 7 to 30 CAD per user per month. For complex business calculations, custom code remains easier to maintain.
How do we avoid losing the old tool's business logic?
Have the macros and queries audited before any development, and run each module in parallel with the old one for 2 to 4 weeks. Calculation differences reveal forgotten rules.
Let's scope your project. Send us the number of tables, users and critical calculations in your Access database, and we will price the scope, an indicative budget and a 3 to 6 month phased migration plan. 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.