The verdict in three sentences
A 2009 Access database that nobody fully understands is an operational risk, not a minor annoyance: one failing workstation or Windows update can freeze invoicing for days. Migrating to a custom web application costs USD 15,000 to 40,000 in 2026 for a 45-employee SME, over 2 to 4 months, including 3 to 8 days of data migration. The right move is a 5-day database audit before pricing, because data quality, not the number of screens, is what drives the budget.
Why Access and Excel became a risk in 2026
In Toronto and across Ontario, many manufacturing, distribution and service SMEs still run on an .mdb or .accdb file built by a former employee or an intern. The pattern is familiar: one machine is the source of truth, VBA macros are undocumented, the file approaches the 2 GB limit and concurrent access regularly corrupts the database. Microsoft still ships Access in Microsoft 365 but no longer invests in multi-user scenarios, and hybrid work makes VPN access slow and fragile.
| Warning sign | Frequency seen in SMEs | Estimated impact |
|---|---|---|
| Access database > 1.5 GB | 1 in 3 audited SMEs | Corruption, weekly compacting |
| VBA macros with no reachable author | 6 in 10 cases | No change possible |
| More than 5 concurrent users | Common from 30 staff | Locks, lost entries |
| Linked Excel files (> 10) | Very common | Formula errors, duplicates |
| Manual backup on USB stick | 1 in 4 SMEs | Weeks of data at risk |
| Remote access via VPN only | Majority | Slowness, limited remote work |
| No change history | Almost always | Disputes, PIPEDA exposure |
The hidden cost is measured in hours: re-keying, cross-checks, calls to the one person who knows. In a 45-person SME, 10 to 20 hours lost per week is common, roughly USD 18,000 to 36,000 per year as a 2026 order of magnitude.
How much a web app migration costs
Price depends on three factors: the number of tables and business rules to rebuild, the quality of historical data, and the integrations required (accounting, ERP, email). Here are typical 2026 ranges for custom development for a Toronto SME.
| Scope | 2026 price (USD) | Timeline | Data migration |
|---|---|---|---|
| Audit of the existing database | 2,500 to 4,500 | 5 days | Table mapping |
| Simple migration (10 to 15 tables, 3 roles) | 15,000 to 22,000 | 2 months | 3 days |
| Standard migration (20 to 40 tables, workflows) | 22,000 to 32,000 | 3 months | 5 days |
| Complex migration (50+ tables, ERP connectors) | 32,000 to 40,000 | 4 months | 8 days |
| Accounting connector (QuickBooks, Sage, Xero) | 3,000 to 6,000 | 2 weeks | Included |
| Canadian hosting + backups | 80 to 250 / month | Immediate | Daily backup |
| Ongoing maintenance | 300 to 900 / month | Continuous | Fixes and features |
For comparison, a generic SaaS tool (Airtable, Notion, a light ERP) costs USD 15 to 45 per user per month, or USD 8,000 to 24,000 per year for 45 users, without your specific business rules. Custom software pays off once the tool carries a process that differentiates you: pricing logic, shop-floor scheduling, lot tracking.
Data-loss risk: how to assess and control it
Data migration is where projects slip. A 17-year-old Access database almost always contains duplicate customers, text fields used for dates and orphan records. A serious method follows four steps: full extraction, cleansing with rules validated by your teams, a dry-run migration on a test environment, then a Friday-evening cutover with one week of parallel running.
| Migration step | Duration | Typical anomaly rate | Deliverable |
|---|---|---|---|
| Extraction and inventory | 1 day | Not applicable | Data dictionary |
| Cleansing and deduplication | 1 to 3 days | 3 to 12% of records | Anomaly report |
| Dry-run migration | 1 to 2 days | Under 1% | Validated test database |
| Cutover and checks | 1 day | Under 0.1% | Acceptance sign-off |
| Parallel running | 5 business days | Logged gaps | Old database retired |
With this protocol, residual loss risk becomes marginal, and the old database is archived read-only for at least 12 months.
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
Daniel, owner of a 45-employee technical equipment distributor in Toronto, runs quotes, inventory and after-sales in a 2009 Access database plus 14 Excel files. His team loses about 15 hours a week on re-keying and checks: 15 h x 45 weeks x USD 45 loaded cost = USD 30,375 per year. He commissions a USD 3,500 audit, then a USD 28,000 standard migration, plus USD 1,800 per year of hosting. First-year investment: USD 33,300. If the app recovers 80% of lost hours, the annual gain reaches USD 24,300: payback arrives in about 16 to 17 months, before even counting the removed outage risk.
FAQ
Can Access keep running during the migration?
Yes, and it is recommended: the old database stays in production until cutover, then goes read-only. Parallel running usually lasts 5 business days.
How long does it take to replace an Access database?
Allow 2 months for a simple 10 to 15 table database and up to 4 months for a complex one with connectors. The initial audit takes 5 days.
Can VBA macros be migrated automatically?
No, they are rewritten as server-side business rules, often 20 to 30% of the budget. It is also a chance to drop processes nobody uses anymore.
Where is the data hosted?
With a hosting provider in Canada, for USD 80 to 250 per month, with daily backups and 30-day retention, in line with PIPEDA.
Does a web app work offline?
A PWA version can store entries offline and sync them later, for an extra USD 3,000 to 6,000.
Let's scope your project. Send us your database size, user count and accounting integrations: we will price the audit and migration, indicative budget USD 15,000 to 40,000, delivered in 2 to 4 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.
