Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · Tuesday · 46 min

Microsoft Access or Web App? Choosing the Right Path for Your Business

Do you really need to replace a working Microsoft Access application just because remote employees, mobile devices, or web access are entering the picture? Often, the answer is no. The important question is not whether Access is old, but what business problem actually needs to be solved. This episode separates the Access front end from the database backend and explains why they do not have to be replaced together. A business can move shared data to SQL Server, keep familiar Access forms, reports, queries, and VBA for office staff, and add a focused web or mobile interface only where it is needed. Learn why opening an ACCDB file directly over the internet is a bad idea, why the 2 GB Access file limit does not necessarily mean an Access application cannot grow, and when remote desktop, SQL Server, a customer portal, or a full web application makes sense. A mature Access database often contains years of business rules, automation, reports, and hard-earned exceptions. Before rebuilding it all, make sure you are solving a real requirement instead of reacting to marketing.

0:00-46:36
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Do you really need to replace a working Microsoft Access application just because remote employees, mobile devices, or web access are entering the picture? Often, the answer is no. The important question is not whether Access is old, but what business problem actually needs to be solved.

This episode separates the Access front end from the database backend and explains why they do not have to be replaced together. A business can move shared data to SQL Server, keep familiar Access forms, reports, queries, and VBA for office staff, and add a focused web or mobile interface only where it is needed.

Learn why opening an ACCDB file directly over the internet is a bad idea, why the 2 GB Access file limit does not necessarily mean an Access application cannot grow, and when remote desktop, SQL Server, a customer portal, or a full web application makes sense.

A mature Access database often contains years of business rules, automation, reports, and hard-earned exceptions. Before rebuilding it all, make sure you are solving a real requirement instead of reacting to marketing.

more episodes

All episodes