Get The Access Migration Playbook
19 chapters, 6 appendices, 64,500+ words of practical guidance.
$19.99
Or scan to purchase on your phone:
Book 1 of The Database Migration Field Guide Series
Why Your Access Database Needs to Change — And What It Actually Takes
$19.99
Your Access database was never supposed to run the business. But here you are — dealing with corruption, multi-user failures, no security, no audit trail, and a 2GB wall that's getting closer.
This book is your complete guide to what comes next. No hype, no vendor pitches — just honest assessments of every option: keeping your Access front-end with a real database back-end, replacing everything with Python, building a web application, going hybrid, evaluating Power Apps, or using SQLite.
Includes 11 real-world migration horror stories, a decision framework to match your situation to the right approach, VBA-to-Python translation guide, SQL dialect cheat sheet, pre-migration checklist, and complete code examples.
Written for IT professionals, consultants, and business owners who need a plan — not a sales pitch.
You didn't plan for this. Nobody ever does.
Somewhere, years ago, someone in your organization — maybe you — built "a quick little database" in Microsoft Access. It was supposed to track a few things. Maybe it was customer orders. Maybe it was inventory. Maybe it was a job-tracking system for a dozen employees. It took a weekend, maybe a week, and it worked. It worked great, actually. People loved it. They could enter data, pull reports, and stop managing everything in spreadsheets.
That was the beginning of the problem.
Access is a victim of its own ease of use. No other tool in the history of software lets a reasonably smart person go from "I need to track something" to "I have a working database application" as fast as Access does. You drag some fields onto a form, link a few tables, write a query or two, and suddenly you have something people depend on.
And because it works, people start depending on it more. First it was one department. Then another department heard about it and wanted their own forms. Someone asked for a report that cross-references two tables. Someone else needed a button that sends an email when an order ships. The VBA code grew. The table count grew. The user count grew.
Nobody held a meeting and decided "this Access database will become the backbone of our business." It just happened, one feature request at a time.
19 chapters, 6 appendices, 64,500+ words of practical guidance.
$19.99
Or scan to purchase on your phone: