The verdict in three sentences
For a 25-employee wine importer and distributor in Toronto, replacing a 2009 Access database with a custom web app costs CAD 38,000 to 68,000 and takes 4 months, data migration included. A standard wine distribution ERP is cheaper over three years (CAD 23,000 plus CAD 900 per month) but handles en primeur allocations poorly, which are often the reason the Access database exists. Either way, doing nothing exposes the business to an outage estimated at 3 days of sales, more than CAD 80,000 in gross margin.
Why the Access database has become a business risk
The situation is common among wine distributors: an Access database built in 2009 by an enthusiastic employee handles 4,000 SKUs, en primeur allocations per customer, prices per channel (restaurants, retail, private orders) and picking slips. It works, but only one employee can maintain it, it crashes beyond 5 simultaneous users and sales reps cannot use it remotely or on mobile.
| Risk | Estimated 12-month probability | Impact if it happens | Indicative cost |
|---|---|---|---|
| Departure or long absence of the only maintainer | 15 to 25% | Database frozen, no changes possible | CAD 15,000 to 30,000 emergency takeover |
| Corrupted .accdb file | 10 to 20% | 1 to 3 days without order entry | CAD 27,000 to 81,000 in margin |
| End of Office support or incompatibility | 20 to 30% | Workstations stuck on an old version | CAD 4,500 to 12,000 |
| Customer data leak (copied file) | 5 to 10% | Privacy breach reporting, lost trust | CAD 7,500 to 45,000 |
| En primeur allocation errors | 30 to 40% | Unhappy customers, disputes | CAD 3,000 to 15,000 per campaign |
These probabilities are estimates drawn from similar projects, not official statistics. The CFO's reference calculation remains the key one: with CAD 27 million in revenue and a 25% gross margin, each day of blocked sales represents about CAD 27,000 in margin.
Three costed options for 2026
| Criterion | Keep Access and document it | Off-the-shelf distribution ERP | Custom web app |
|---|---|---|---|
| Initial cost | CAD 4,500 to 9,000 | CAD 23,000 + CAD 12,000 to 23,000 configuration | CAD 38,000 to 68,000 |
| Recurring cost | CAD 0 | CAD 900 per month | Maintenance CAD 600 to 1,050 + hosting CAD 120 to 225 per month |
| 3-year total cost | CAD 4,500 to 9,000 + risk | CAD 67,400 to 78,400 | CAD 64,000 to 114,000 |
| En primeur allocations | Yes (existing) | Partial or via custom development | Yes, replicated then improved |
| Mobile access for sales reps | No | Yes | Yes, mobile PWA |
| Time to production | 2 weeks | 3 to 5 months | 4 months |
| Ownership and reversibility | Yes | Depends on the vendor | Yes, code and data |
The conclusion is nuanced. If your processes are close to industry standard, the ERP is the best economic choice. If allocations, channel pricing rules and customer history are your competitive edge, the custom app keeps the logic that made your Access database successful, without its limits.
How a 4-month project unfolds
| Phase | Duration | Deliverable | Share of budget |
|---|---|---|---|
| Access database audit (tables, queries, VBA macros) | 2 weeks | Map of data and business rules | 10% |
| Design and mock-ups | 3 weeks | Flows approved by sales management | 15% |
| Development in batches | 8 weeks | SKUs, customers, allocations, orders, picking | 50% |
| Data migration and cleaning | 2 weeks (in parallel) | 4,000 SKUs and 15 years of history migrated | 15% |
| Acceptance, training, cut-over | 3 weeks | One week of double entry, then Access retired | 10% |
The critical point is migration: a 15-year-old Access database contains duplicate customers, vintages entered in several formats and undocumented VBA macros. Reserving 15% of the budget for cleaning avoids bad surprises during acceptance testing.
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.
Michael, CFO of a 25-employee wine importer in Toronto, chooses a custom web app at CAD 54,000, with maintenance at CAD 825 per month. The sales administration team (3 people) saves 40 minutes per person per day thanks to single data entry and mobile access for reps, which adds up to 2 hours a day. Over 220 days, that is 440 hours, valued at CAD 52 loaded cost, or CAD 22,880 per year. After maintenance (CAD 9,900 per year), the net gain is CAD 12,980 per year. Ignoring risk, payback takes about 4 years. But a single avoided 3-day outage, worth CAD 81,000 in margin, pays for the project one and a half times.
FAQ
How much does replacing an Access database with a web app cost?
For a 25-employee distributor with 4,000 SKUs, budget CAD 38,000 to 68,000, data migration included. Expect about 4 months with one week of double entry.
Can we keep historical data?
Yes, 15 years of history are migrated after removing duplicates. This step is about 15% of the budget, or CAD 6,000 to 10,500.
Isn't a distribution ERP cheaper?
Over 3 years, an ERP costs CAD 67,400 to 78,400 including configuration, versus CAD 64,000 to 114,000 for custom. It is more economical if your allocation rules stay simple.
What does CAD 600 to 1,050 per month of maintenance cover?
Bug fixes, security updates, monitoring and 3 to 6 hours of minor changes per month. New features are quoted separately.
Can we start with a single module?
Yes, many distributors start with en primeur allocations (about CAD 18,000), then migrate orders and picking the following quarter.
Let's scope your project. We audit your Access database in 2 weeks and price the migration (scope, a CAD 38,000 to 68,000 budget, cut-over in 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.
