Forum Discussion
Moving Away from MS Access
Hi all,
since the AUG Access Pacific Presentation on Alternative solutions at the beginning of August 2024 did not go through (I think), may I present the progress we have made with moving the Access templates to the Web?
https://msaccess.pythonanywhere.com
https://northwind.pythonanywhere.com
https://northwind2.pythonanywhere.com
https://assetinventory.pythonanywhere.com
And some apps from our users:
https://resourcingandbilling.pythonanywhere.com
https://kanban.pythonanywhere.com
https://sem.pythonanywhere.com
https://carparts.pythonanywhere.com
https://positionstracking.pythonanywhere.com
Pls find Help with notes about the "migration".
This apps are now running for quite some time, like a year or two, with absolutely no issues, and zero downtime (except PA maintenance). This are simple apps to get one going. The RFM analysis on NWT is not that simple though, but just a few lines of code.
Also, NWT v7 has API call to Account Ledger. This is the only table not read only. Change something on Account Ledger, and NWT will fetch the amount.
The Pivot table is a drag/drop report engine, it is literally no code report solution. Fantastic for "smaller" data. We also presented the server side SQL for "big" data.
Apps can contain History/roles/privs etc. and authenticate against OAuth, SAML, db passwords, etc.
Hope this will help to someone. Pls shout out any questions. I do not benefit from this at all, since all is Open Source.
Oh, and all v7 apps are mobile devices ready since using Boostrap 4. So just hook up this sw to mssql, etc, and off u go.
Thanks