The verdict in three sentences
In Montréal in 2026, replacing a legacy Access database or business-critical Excel workbook with a web app costs, as an order of magnitude, CAD 18,000 to 50,000 with a local firm for 15 to 80 tables and 10 to 25 users, over 8 to 14 weeks. Once live, the app carries no per-user licence, whereas generic SaaS charges CAD 14 to 35 per user per month without matching your business rules. Success depends on a data migration tested on a copy before cutover, and in Québec on an interface where French is available and at least as prominent as English, as Bill 96 requires.
Why the Access database has become a risk
Many Québec SMEs (distribution, construction, manufacturing, transport) still run on an Access database built around 2009 by an employee who has long since left. It works until it does not. The symptoms are familiar: a shared file that corrupts when two people open it, undocumented VBA macros, no remote access, and manual Excel exports every month end.
| Symptom | Typical frequency | Consequence |
|---|---|---|
| Corrupted .accdb file | 1 to 3 times a year | 1 to 2 days of lost entries, backup restore |
| 2 GB size limit reached | After 10 to 15 years of history | Manual archiving, split data |
| Limited concurrent access | Above 5 to 10 users | Slowness, locks, re-keying |
| Undocumented VBA macros | Almost always | No safe way to evolve |
| No remote or mobile access | Always | Office-bound staff, improvised VPN |
| English-only screens and reports | Common | Exposure under the Charter of the French language |
What the migration costs
Price depends mainly on the number of tables, the logic hidden in queries and macros, and the data volume to migrate.
| Legacy profile | Tables | Users | Montréal firm, order of magnitude | Duration |
|---|---|---|---|---|
| Business Excel workbook with formulas | 3 to 10 sheets | 5 to 10 | CAD 12,000 to 20,000 | 6 to 8 weeks |
| Small Access database | 15 to 25 | 10 to 15 | CAD 18,000 to 28,000 | 8 to 10 weeks |
| Medium Access with reports and macros | 25 to 50 | 15 to 20 | CAD 26,000 to 40,000 | 10 to 12 weeks |
| Large Access with accounting interfaces | 50 to 80 | 20 to 25 | CAD 36,000 to 50,000 | 12 to 14 weeks |
On the Kolonell grid, a simple business web app sits at 2,500,000 to 4,000,000 FCFA (3,810 to 6,100 EUR), a medium app at 4,000,000 to 7,000,000 FCFA (6,100 to 10,670 EUR) and a complex app at 7,000,000 to 15,000,000+ FCFA (10,670 to 22,870+ EUR). Most 25 to 50 table Access databases fall into the medium or complex band. Maintenance then runs 35,000, 75,000 or 120,000 FCFA per month (53, 114 or 183 EUR). Languages are set in the quote.
Custom app or generic SaaS
| Criterion | Custom web app | Generic SaaS (Airtable, online vertical tool) |
|---|---|---|
| Upfront cost | CAD 18,000 to 50,000 | CAD 0 to 4,000 setup |
| Licence | CAD 0 per user | CAD 14 to 35 per user per month |
| 5-year cost for 20 users | Build plus maintenance | CAD 17,000 to 42,000 in licences alone |
| Specific business rules | Reproduced exactly | Bent to the tool's model |
| French-language interface | Built in from day one | Depends on the vendor |
| Data residency | Canada, your choice | Often US-hosted |
A migration method that avoids surprises
- Inventory: tables, queries, forms, reports and macros, reviewed with the key user. One to two weeks.
- Data model: remove duplicates, normalise, move to PostgreSQL.
- Migration on a copy: a script imports a copy, then control totals (customers, revenue per year) are compared with Access. Repeat until zero variance.
- Parallel run: two weeks using both tools on the same files.
- Cutover on a Friday evening, Access set to read-only and archived.
Québec's Law 25 on personal information also pushes for a privacy impact assessment when data moves to a new system, which the inventory step feeds directly.
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.
Marc-André Tremblay, controller at a food distributor in Laval near Montréal, manages 42 Access tables, 18 users and 14 years of history. The chosen quote is CAD 36,000 over 11 weeks.
Estimated time saved: 1 hour per user per week (re-keying, exports, locks), so 18 × 45 weeks = 810 hours a year at a loaded CAD 50: CAD 40,500 a year. Generic SaaS would have cost 18 × CAD 25 × 12 = CAD 5,400 a year without removing all re-keying. With about CAD 2,000 of yearly maintenance, net gain is CAD 38,500 a year: payback in about 11 months.
FAQ
How much does replacing an Access database cost in Montréal in 2026?
As an order of magnitude, CAD 18,000 to 50,000 depending on tables (15 to 80) and users (10 to 25). A simple business Excel workbook starts around CAD 12,000.
Will we lose data during migration?
Not if the migration is tested on a copy and validated with control totals. The import is repeated until zero variance, and the cutover itself usually takes one evening.
Does the app have to be in French?
Under Bill 96, software used at work in Québec must be available in French when a French version exists, and the interface should give French at least equal prominence. Building both languages from the start costs far less than retrofitting.
How much time must our team commit?
Plan 2 to 4 hours a week for the key user over 8 to 14 weeks, plus a two-week parallel run.
Where is the data hosted?
With a Canadian data centre if you wish, with daily backups kept for 30 days, which supports Law 25 compliance.
Let's scope your project. Send us the list of tables and uses of your Access or Excel system, and we will price the migration and an 8 to 14 week timeline. 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.
