Forum Discussion
Moving Away from MS Access
The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to. Is there ...
We are in a similar boat as you. We have 12 DB's, no need for internet based apps on our phones, and love how simple Access is to develop, maintain, and program - esp for prod releases, so simple. The problem is we now have WFH (work from home) users where if everything was on the cloud and sharepoint we could avoid having to use on-prem VM's for Access files. But that means a complete redesign of every internal process and DB plus our TSQL based SOR from the late 90's from VS6 does not work on Azure. Replacing Access with anything will cost millions in pay roll and licensing, its just not worth it.<br><br>With that said I am currently researching using Blazor or WPF just to get a real-life dollar cost for converting off of Access just so I am not fooling myself one way or the other.
SharePoint will cost millions. I would know, we are paying approx $120 000 per month.
I would just love to see those apps guys. And believe me, I've seen more than 300, and of that 300, one or two were sort of good. And that's only the FE, the BE was not that great.
Take for example the Northwind Traders app. Now, compare this with the online one we created in just about 10 hrs.
The technology is there. What you are looking for is a magic wand. Unfortunately, the time is just passing, and while you are looking for one, half of the job could be done.
If not all of it.
My company is running Oracle Forms/Reports which are 20 years old. You know what? Oracle is gladly taking 20 000 000 dollars for the support of the monster we created. So yes, it's not uncommon to look for a magic wand indefinitely.
The team of 5 developers could replace this in 6 months. This is a political question, not a business or the technology one. Blame the managers and "powers to be" for the mess they created.
I would just love to see those apps guys. And believe me, I've seen more than 300, and of that 300, one or two were sort of good. And that's only the FE, the BE was not that great.
Take for example the Northwind Traders app. Now, compare this with the online one we created in just about 10 hrs.
The technology is there. What you are looking for is a magic wand. Unfortunately, the time is just passing, and while you are looking for one, half of the job could be done.
If not all of it.
My company is running Oracle Forms/Reports which are 20 years old. You know what? Oracle is gladly taking 20 000 000 dollars for the support of the monster we created. So yes, it's not uncommon to look for a magic wand indefinitely.
The team of 5 developers could replace this in 6 months. This is a political question, not a business or the technology one. Blame the managers and "powers to be" for the mess they created.