3 ms·
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, Pos
by Someone1234 11y ago
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.