@Dashrender said in Access 2003 in a 2021 World???:
@scottalanmiller said in Access 2003 in a 2021 World???:
@Pete-S said in Access 2003 in a 2021 World???:
@Dashrender said in Access 2003 in a 2021 World???:
@DustinB3403 said in Access 2003 in a 2021 World???:
And yes I know that best is relative to ones needs.
Access was the "best" at one point I'm sure.
I'm willing to bet that's not true - not a lot.. maybe $100... lol pretty sure Access was never the best for anything.. other solutions while possibly more difficult could still likely be shown to be much better solutions.
It wasn't Access itself that was the thing. It was the JET database engine that Access used under the hood that made it popular.
Back in the 90's if you wanted a simple database in your application and you used something like Visual Basic 3.0 then the JET engine was the first option to consider because Microsoft bundled it with VB and it was free. That's how it gained a foothold.
The JET engine was very very far from the best or even good. It was common to corrupt the database and run tools to "repair" it. But it was available without any effort - today we know that is perhaps the most important "feature"...
If you wanted the best you'd connect your application to an Oracle db.
MS Access itself was never a serious tool that developers used for business applications. It's very limited so VB was the default choice in the MS ecosystem for these kinds of applications.
Once Access could use SQL Server, it became worlds better. But the whole "GUI application interface" made it so expensive and limiting that it could never really be a great tool, even when it was a good enough tool.
I've got customers who have built way too much on it and even though they are tiny and use it about as well as anyone could, it's really clear that if they put a little effort into a PHP developer that they could replace everything in a week with something vastly better.
A week? you mean 40 hours at $250/hr (dev house)?
40 hours, a PHP dev sure isn't $250/hr. That's an ERP cost per hour. Contract a developer for a week and you can definitely find someone who will work at much more like $85/hr if you shop around and find someone available.