Hacker News new | comments | ask | show | jobs | submit login

I'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.



What are the modern alternatives to Access? Web frontends?


I'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.


In 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.)


When departments have been abandoned from an IT budget, the most common replacement I've seen has been SharePoint.

Not a bad replacement.


A 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.


Fascinating. I've not before this comment seen someone mention Dynamics CRM as "quick development" (and at one point that included knowing actual Dynamics CRM devs, but that was back before .NET integration and the worst excesses of X++ were still plentiful).

From my perspective across a number of jobs and project clients, SharePoint installations are rare (and often out-of-date and equally often loathed) and I've never actually seen a Dynamics CRM install in the wild. (I know they exist, I've just never seen one/worked with one.)

I admire your use of Dynamics CRM as a hammer for all nail-like objects as a means of job security.




Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact

Search: