Remix.run Logo
samplatt a day ago

>In 2026, Microsoft Access is still fully supported and bundled into Microsoft 365 Enterprise subscriptions.

Having a subscription is only a small part of the total cost. Access works best when combined with a bunch of VBS/macro scripts, which IT departments globally are trying very hard to stamp out completely. Access also needs its own set of permissions and manager of permissions since it can't inherit permissions from anywhere of the other usual Microslop security stores - at least, not without having its own developer/maintainer/champion on tap.

Not to mention the agreed wisdom that while Access is fantastic for rapid-prototyping applications/warehouses/ETL processes, any "permanent" DB/DBMS/solution worth doing in Access is worth doing in a 'proper' database with a proper front-end.

jordand a day ago | parent | next [-]

All true and yeah, I did discuss with my employer at the time about how they needed to think long term about migrating to SQL Server or MySQL/PostgreSQL with a web front-end. However, the giant IT contractor they were stuck with would only allow SQL Server and charge a fortune, and they didn't have the time/money/know-how to go anywhere with that. They were stuck with Access!

EvanAnderson a day ago | parent | prev [-]

> Access works best when combined with a bunch of VBS/macro scripts...

You're thinking of Visual Basic for Applications (VBA), which is interpreted inside of Access. The standalone Visual Basic Scripting (VBScript) is a completely different thing, and eliminating VBScript doesn't have any ramifications for Access.

samplatt 21 hours ago | parent [-]

Ugh, yeah. VBA not VBS. I'd like to say "the keys are right next to each other", but the truth is I've been in both those worlds for far too long...