The verdict in three sentences
Replacing a business-critical Access or Excel tool with a web application costs CAD 25,000 to 70,000 in Toronto in 2026, and EUR 15,000 to 45,000 in a French regional hub such as Nantes, over 8 to 14 weeks including data migration. The real risk is not the project cost but dependency on a single person who maintains a 2009 database whose macros nobody else understands. A well-scoped application usually pays for itself in 12 to 24 months through eliminated re-keying.
Signs that migration is urgent
In many mid-sized firms, from Ontario manufacturers to distributors and engineering subcontractors, production runs on an Access database built fifteen years ago by a resourceful employee. It works, until the day it does not: a retirement, a corrupted file, an Office update that breaks a VBA macro, or remote work that makes the shared file unusable.
| Warning sign | Concrete risk | Urgency |
|---|---|---|
| Only one person can modify the database | Tool stops when they leave | High |
| .accdb file close to 2 GB | Corruption, data loss | High |
| Several "final version" Excel copies circulate | Decisions made on wrong numbers | Medium to high |
| No access outside the plant network | Remote work and sales reps blocked | Medium |
| No trace of who changed what | Client disputes, ISO 9001 non-compliance | Medium |
| VBA macros break with every Office update | Repeated hours of troubleshooting | Medium |
| Manual re-keying into ERP or accounting | 5 to 20 hours lost per week | Medium |
If you tick three lines or more, the project is no longer a comfort upgrade: it is a business continuity measure.
Cost and timeline by complexity
Budget depends on the number of screens, the complexity of business rules hidden in queries and macros, and the volume of data to migrate. A typical Access database holds 50,000 to 500,000 rows across 15 to 60 tables, with duplicates and free-text fields used for everything.
| Existing tool profile | Web app scope | Timeline | Nantes budget (EUR) | Toronto budget (CAD) |
|---|---|---|---|---|
| Shared Excel workbook, 3 to 5 tabs | 6 to 10 screens, 2 roles, Excel export | 8 weeks | 15,000 to 20,000 | 25,000 to 32,000 |
| Simple Access, 15 tables, 50,000 rows | 10 to 15 screens, 3 roles, history | 9 to 10 weeks | 20,000 to 28,000 | 32,000 to 42,000 |
| Access with VBA, 30 tables, 200,000 rows | 15 to 25 screens, approval workflow | 10 to 12 weeks | 28,000 to 36,000 | 42,000 to 56,000 |
| Access + satellite Excel files, 500,000 rows | 25 to 35 screens, ERP or accounting connector | 12 to 14 weeks | 36,000 to 45,000 | 56,000 to 70,000 |
| Post-launch maintenance and hosting | Fixes, backups, minor changes | Monthly | 300 to 900 per month | 500 to 1,400 per month |
For comparison, a low-code option (Power Apps, AppSheet) starts at EUR 8,000 to 12,000 (CAD 12,000 to 18,000) of configuration, but adds EUR 10 to 25 per user per month and often hits a wall with complex business rules. Custom development stays more cost-effective from 25 to 30 users over 5 years.
The five-step method
1. Inventory (1 to 2 weeks). We open the database, list tables, queries, forms, reports and macros, and interview the person who maintains it. This is where unwritten business rules hide: a discount calculation, a status that changes on its own, a Friday export.
2. Clean data model. We normalise tables, remove duplicates and define keys. Allow 10 to 20 % of the budget here, as it drives reliability.
3. Development in batches. Most-used screens first, delivered every two weeks and tested by real users.
4. Data migration. A migration script tested at least three times on copies, with total checks (row counts, sums of amounts) before and after.
5. Cutover and parallel run. Two to four weeks during which the old database stays read-only for verification, then archiving.
Role-based access (who sees, who edits, who approves) and change history are built in from day one: they are what Access lacks most, and what quality auditors ask for.
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
Sylvie, office manager at a 60-person metal fabrication SME in Nantes, depends on a 2009 Access database that manages work orders. Three people re-key data every day into the ERP and a client tracking spreadsheet.
- Time lost: 3 people x 5 hours per week = 15 hours per week, about 690 hours per year
- Average loaded cost: EUR 38 per hour, i.e. EUR 26,220 per year
- Project: 18-screen web app, 180,000 rows migrated, ERP connector: EUR 34,000 in 11 weeks, plus EUR 600 per month maintenance (EUR 7,200 per year)
- Net annual gain: 26,220 - 7,200 = EUR 19,020, payback in roughly 21 months
A Toronto firm with the same profile would pay around CAD 52,000 and, at CAD 45 loaded hourly cost, save about CAD 31,000 per year, for a similar payback. Neither calculation counts the risk avoided if the only employee who understands the database retires next year.
FAQ
How much does replacing an Access database cost in Toronto?
CAD 25,000 to 70,000 in 2026 depending on tables, macros and screens, versus EUR 15,000 to 45,000 in Nantes. A simple 15-table database lands around CAD 32,000 to 42,000.
How long does the project take?
8 to 14 weeks, including 1 to 2 weeks of inventory and 2 to 4 weeks of parallel run. Users see the first screens by week 4 or 5.
Can all historical data be migrated?
Yes, including 500,000 rows or more. Totals are checked before and after migration, and unusable records (duplicates, empty fields) are flagged for a decision.
Why not stay on Excel with SharePoint?
That works for fewer than 5 users and simple rules. Beyond that, the lack of fine-grained permissions, reliable history and input validation often costs more than 10 hours a week.
What happens after go-live?
A maintenance contract of EUR 300 to 900 (CAD 500 to 1,400) per month covers hosting, daily backups, fixes and small changes. You own the code and the data.
Let's scope your project. Send us a copy of your Access database or spreadsheet: inventory, scope, budget and an 8 to 14 week 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.