Lifecycle & risk
Limits & failure modes
-
Why Your Multi-User Access Database Keeps Corrupting
Microsoft Access corruption is a symptom, not a disease. The three real causes: an unsplit database, a shaky network path and too many concurrent writers.
-
The Microsoft Access 2GB Limit Explained: What Actually Happens When You Hit It
Microsoft Access caps each database file at 2GB. What the limit really counts, why compact and repair only buys time, and the four ways out.
-
Microsoft Access over Remote Desktop, VPN or "the Cloud": Why It Never Feels Right
Microsoft Access was designed for a file on a local network. Here is what VPN, Remote Desktop, cloud sync and SharePoint each cost, and what does work.
Migration mechanics
-
Converting Access VBA to a Web Application: What Translates, What Doesn't, and What Gets Better
Microsoft Access VBA does not port line by line, but nearly all of it translates. A construct-by-construct map of what becomes what and what disappears.
-
How to Convert a Microsoft Access Database to a Web Application: The Whole Process, Step by Step
The six-step process for converting a Microsoft Access database into a web application: audit, data model, screens, logic, migration and the parallel run.