4 ms·
Ask HN: How many of your clients still use MS Office Access?
- nslindtner 11y agoOne of my large client is dependent on it with 100 access systems. SQL server is the backend though.
- a_shiri 11y agoI didn't get you by Ms Access
- tuyguntn 11y agoUpdated title
- twunde 11y agoWe have a consultant that specializes in the industry and she runs everything off of Access.
- kjs3 11y agoAll of them. Seriously. I long ago stopped being surprised when I find my client using some long-ago enshrined Access app to handle a critical business function. Nothing compared to Excel, tho...
- edimaudo 11y agoA lot of large corporations.
- WorldMaker 11y agoI've been working with several applications that are Access-based in one way or another. Most of these apps are "ancient". Some of my job is to migrate these apps to modern solutions, but a lot of that depends on project budgets.
- ptype 11y agoWhat are the modern alternatives to Access? Web frontends?
- Someone1234 11y agoI'm not sure I'd call it "modern" (or not) but typical strategies for getting away from MS Access: - Move data into any DBMS (e.g. SQL Server, Oracle, IBM, Postgres, etc). - Get a reporting solution that hooks into the DBMS (SQL Server Reporting Services, Power BI, Domo, Tableau, SAP Crystal Reports, IBM Cognos, et al). - Reproduce the reports you have in Access in the reporting solution. These reports CAN be delivered via HTTP/HTML, or even created that way in some cases. But they can also deliver reports in static formats (Excel spreadsheets, PDFs, images, etc). The power of MS Access is the reports building functionality (and forms which generate reports with bespoke values). You can actually point Access at a DBMS and it still remains a powerful tool. Most companies won't move away from MS Access in one go. They'll move their data and then later move their reports, and most of the reason to move reports is to better centralise operations (no more Access file on Bob's computer which Sam cannot access) and provide an improved remote access facility.
- WorldMaker 11y agoIn my particular case these are really custom applications for data collection and analysis. One wants to be more "mobile first" and another does want to be "web-oriented" to make it easier for users. (Plus, one is VB6 using Access as DBMS and the other is a hodge-podge of Access and Matlab.)
- zhte415 11y agoWhen departments have been abandoned from an IT budget, the most common replacement I've seen has been SharePoint. Not a bad replacement.
- kfullert 11y agoA better replacement in my opinion is Dynamics CRM (biased as I'm a Dynamics CRM consultant) ... speed of development is quick, runs everywhere with just one set of code (web, desktop app, mobile app, mobile web) and if you need to do something outside the standard functionality it's really quick and easy to write a C# plugin or custom workflow activity to do what you want.
- mike22 11y agoI'm doing QA on a replacement for a VB6 / Access application for a large and slow-moving utility company. Funny thing is that the consultants building the app on the hot, super-awesome BPM platform move at the same pace, and each build includes more bugs and fewer new features to test than the last.
- conrmahr 11y agoWe converted an Access front-end connected to a SQL Server instance and rebuilt the front-end with Rails to have a internal website for data entry and Tableau to automate reports. Highly recommend.
- Spooky23 11y agoWe have a business unit that gave up on IT writing mobile apps for them. So they made an Access app with giant buttons that would run on vdi. They figured out how to automate 4-5 key business functions on iPad, which saves them a ton of time in the field. The brass found out about it, and has spent $400k writing a "proper" replacement, but have been 75% complete for 3 months.