Access 2003 in a 2021 World???
-
@Carnival-Boy said in Access 2003 in a 2021 World???:
@Dashrender said in Access 2003 in a 2021 World???:
If you have all those different products, you likely have tons of work-arounds you have to do to get data to work together... plus the cost of managing them all separately...
I agree, it does seem like a lot of work. I can't see the attraction. It feels a bit too 1980s.
The problem is getting a company to see how much they are actually spending on their ERP components.
I have a vendor that has an ancient AS400, running Daily and Wilcot. I don't think the software has received an update in 15 years, possibly more like 20+. I've been begging them to move to another platform for 5+ years - old hardware, hard to get replacements, etc...
They really need to move to another platform, In light of this conversation, I wonder if they would be better off hiring someone like Bundy or NTG (I think they do dev) to make them a platform for what they need...
Potentially one of the biggest hurdles is getting their old data out.
-
@Dashrender said in Access 2003 in a 2021 World???:
Potentially one of the biggest hurdles is getting their old data out.
Potentially, but not likely.
Those systems are mostly just formatted text records. The only hard part is knowing the data structure and then you just write something to parse it all out out.
I've done it before with a Baby36 system that had a full package wrote in RPG II.
-
@scottalanmiller said in Access 2003 in a 2021 World???:
That kind of budget would easily get you a full time crew of three people, if not more, that create exactly what you want and are there to develop, improve, update, tweak, etc. for forever.
It feels like you believe in outsourcing IT but insourcing ERP. But all the arguments you've made regarding outsourcing IT equally apply to ERP, if not more so. I feel you're taking a contradictory position.
-
@Carnival-Boy said in Access 2003 in a 2021 World???:
@scottalanmiller said in Access 2003 in a 2021 World???:
That kind of budget would easily get you a full time crew of three people, if not more, that create exactly what you want and are there to develop, improve, update, tweak, etc. for forever.
It feels like you believe in outsourcing IT but insourcing ERP. But all the arguments you've made regarding outsourcing IT equally apply to ERP, if not more so. I feel you're taking a contradictory position.
My experience may be skewed, but in my experience, many companies (that are not on the fortune list) that get custom bespoke software don't hire the developers directly. They pay a small development firm to write something for them.
-
@JaredBusch said in Access 2003 in a 2021 World???:
@Carnival-Boy said in Access 2003 in a 2021 World???:
@scottalanmiller said in Access 2003 in a 2021 World???:
That kind of budget would easily get you a full time crew of three people, if not more, that create exactly what you want and are there to develop, improve, update, tweak, etc. for forever.
It feels like you believe in outsourcing IT but insourcing ERP. But all the arguments you've made regarding outsourcing IT equally apply to ERP, if not more so. I feel you're taking a contradictory position.
My experience may be skewed, but in my experience, many companies (that are not on the fortune list) that get custom bespoke software don't hire the developers directly. They pay a small development firm to write something for them.
This would seem like a better option.
I mentioned this to my client that's still on an ancient AS400 - first words out of her mouth - yeah, they write it, then quit and no one knows it or can update it...
Seems like a good reason to go with a company with a development history. -
@Dashrender while I agree, using a tiny dev company may cause the same issues that using a single developer would cause.
Businesses go out of business constantly, so it might make sense to use a well established company with a rather long history.
-
Even with an established software house you're entering in to a very committed relationship. You're relying on one company for modifications, fixes etc for years to come at an unspecified cost.
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
Sure, with typical ERP systems you will have customisations on top, either completely bespoke, or industry specific verticals. But that might only be 20% of the system, with 80% being standard. So moving to another ERP partner means the new partner only has to worry about the 20% of bespoke code, not a completely unknown system that is 100% bespoke.
And the reality is companies are simply not that unique. Many think they are, but the majority of unique business processes are not ones that add value but are a case of "we've always done it like this". Identifying unique processes that add genuine value, whilst standardising other processes, reduces the amount of customisation needed, reduces costs, and actually increases efficiency and business performance.
-
@Carnival-Boy said in Access 2003 in a 2021 World???:
Even with an established software house you're entering in to a very committed relationship. You're relying on one company for modifications, fixes etc for years to come at an unspecified cost.
Like with any Microsoft Product?
-
@Carnival-Boy said in Access 2003 in a 2021 World???:
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
That is why you'd have to use a well known, flexible and capable programming language. Hopefully as you're searching for a software development company, you'd also know to not look for someone who programs in Visual basic.
-
@Carnival-Boy said in Access 2003 in a 2021 World???:
Sure, with typical ERP systems you will have customisations on top, either completely bespoke, or industry specific verticals. But that might only be 20% of the system, with 80% being standard. So moving to another ERP partner means the new partner only has to worry about the 20% of bespoke code, not a completely unknown system that is 100% bespoke.
I would honestly say the difference is even less, at least in my experience. With my prior example the business really only needed one custom report made (granted using Crystal Reports) to really make the software work for the business.
The hundreds of thousands the business previously invested was unable to do what a simple report from the existing database, albeit custom was able to do.
-
@DustinB3403 said in Access 2003 in a 2021 World???:
@Carnival-Boy said in Access 2003 in a 2021 World???:
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
That is why you'd have to use a well known, flexible and capable programming language. Hopefully as you're searching for a software development company, you'd also know to not look for someone who programs in Visual basic.
This is a HUGE part of the problem. This is where being IT is critical - but it's unreasonable for the owner of a HVAC company to be expected to know anything about what programming languages are good ones, which ones will have longevity... so they have to hire it out - but then too - how do they know they've hired well?
Knowing what we know now - programming in Flash was horrible - yet tons of enterprises created countless things in Flash - and continue to use those things, refusing to spend to basically recreate them in something modern.
I'm guessing there's something about things like Flash that @scottalanmiller will tell us was obvious why we should never have used it - but then the question is - where there anything else at the time (late 90's early 2000's) that could do the job? and what situations do we see laid out in front of us today the present similar situations?
I suppose the next question I have, considering I have no answers, is - should we be ready to accept that we need to start over once every 20 or so years because as our technology marches forward it simply leaves old, what I'll call stop gap measures, behind?I think this warrants it's own thread and discussion.
-
Speaking of having to start over every x years - and completely off topic - homes, people often don't seem to be prepared for the maintenance that home require. New windows every 20 or less years seems pretty common and nessecary, just like most roofs need to be reshingled at least every 30 years, HVACs replaced every 20, etc. Yet time and time again, you see people completely unprepared for these massive expenses.
-
@Dashrender said in Access 2003 in a 2021 World???:
@DustinB3403 said in Access 2003 in a 2021 World???:
@Carnival-Boy said in Access 2003 in a 2021 World???:
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
That is why you'd have to use a well known, flexible and capable programming language. Hopefully as you're searching for a software development company, you'd also know to not look for someone who programs in Visual basic.
This is a HUGE part of the problem. This is where being IT is critical - but it's unreasonable for the owner of a HVAC company to be expected to know anything about what programming languages are good ones, which ones will have longevity... so they have to hire it out - but then too - how do they know they've hired well?
Knowing what we know now - programming in Flash was horrible - yet tons of enterprises created countless things in Flash - and continue to use those things, refusing to spend to basically recreate them in something modern.
I'm guessing there's something about things like Flash that @scottalanmiller will tell us was obvious why we should never have used it - but then the question is - where there anything else at the time (late 90's early 2000's) that could do the job? and what situations do we see laid out in front of us today the present similar situations?
I suppose the next question I have, considering I have no answers, is - should we be ready to accept that we need to start over once every 20 or so years because as our technology marches forward it simply leaves old, what I'll call stop gap measures, behind?I think this warrants it's own thread and discussion.
Speaking from experience with flash, it was the only language that let you easily manipulate media at the time. If you needed to play an mp3, it took a single line of flash code and 5 minutes if you had to look up options. Most other languages you had to write a full mp3 player.
Today, basically any modern programing language has that sort of thing built in.
-
@travisdh1 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???:
@Carnival-Boy said in Access 2003 in a 2021 World???:
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
That is why you'd have to use a well known, flexible and capable programming language. Hopefully as you're searching for a software development company, you'd also know to not look for someone who programs in Visual basic.
This is a HUGE part of the problem. This is where being IT is critical - but it's unreasonable for the owner of a HVAC company to be expected to know anything about what programming languages are good ones, which ones will have longevity... so they have to hire it out - but then too - how do they know they've hired well?
Knowing what we know now - programming in Flash was horrible - yet tons of enterprises created countless things in Flash - and continue to use those things, refusing to spend to basically recreate them in something modern.
I'm guessing there's something about things like Flash that @scottalanmiller will tell us was obvious why we should never have used it - but then the question is - where there anything else at the time (late 90's early 2000's) that could do the job? and what situations do we see laid out in front of us today the present similar situations?
I suppose the next question I have, considering I have no answers, is - should we be ready to accept that we need to start over once every 20 or so years because as our technology marches forward it simply leaves old, what I'll call stop gap measures, behind?I think this warrants it's own thread and discussion.
Speaking from experience with flash, it was the only language that let you easily manipulate media at the time. If you needed to play an mp3, it took a single line of flash code and 5 minutes if you had to look up options. Most other languages you had to write a full mp3 player.
Today, basically any modern programing language has that sort of thing built in.
So this leads us down (at least in the one example) the foreseen requirement to have to rebuild most things from scratch as newer better, supported solutions come along... but this is only one example.
-
@Dashrender said in Access 2003 in a 2021 World???:
@travisdh1 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???:
@Carnival-Boy said in Access 2003 in a 2021 World???:
At least with major ERP systems like Microsoft, Oracle or SAP you have a partner network to work with. So if you fall out with your partner, or they put up their fees unreasonably, or they go out of business, then you can simply move to another partner and carry on. That's much, much harder with bespoke software.
That is why you'd have to use a well known, flexible and capable programming language. Hopefully as you're searching for a software development company, you'd also know to not look for someone who programs in Visual basic.
This is a HUGE part of the problem. This is where being IT is critical - but it's unreasonable for the owner of a HVAC company to be expected to know anything about what programming languages are good ones, which ones will have longevity... so they have to hire it out - but then too - how do they know they've hired well?
Knowing what we know now - programming in Flash was horrible - yet tons of enterprises created countless things in Flash - and continue to use those things, refusing to spend to basically recreate them in something modern.
I'm guessing there's something about things like Flash that @scottalanmiller will tell us was obvious why we should never have used it - but then the question is - where there anything else at the time (late 90's early 2000's) that could do the job? and what situations do we see laid out in front of us today the present similar situations?
I suppose the next question I have, considering I have no answers, is - should we be ready to accept that we need to start over once every 20 or so years because as our technology marches forward it simply leaves old, what I'll call stop gap measures, behind?I think this warrants it's own thread and discussion.
Speaking from experience with flash, it was the only language that let you easily manipulate media at the time. If you needed to play an mp3, it took a single line of flash code and 5 minutes if you had to look up options. Most other languages you had to write a full mp3 player.
Today, basically any modern programing language has that sort of thing built in.
So this leads us down (at least in the one example) the foreseen requirement to have to rebuild most things from scratch as newer better, supported solutions come along... but this is only one example.
Sure, but nothing about what the future holds prevents one from using the best solution today.
That I believe is where a lot of the issue comes in, just finding the best solution today to develop in.
-
And yes I know that best is relative to ones needs.
Access was the "best" at one point I'm sure.
-
It's one thing writing a completely bespoke system, but who is going to design this for you? Sitting down a Production Manager (for example) with a blank piece of paper and asking what he wants is a recipe for disaster. Even if they had any idea what they wanted. A Production Manager might roughly know what an MRP routine does, but very few could actually design one from the ground up. It's an extremely complicated algorithm.
-
@Carnival-Boy I agree, which is why most organizations would first look to purchase a stock system that meets most of the businesses needs, and then customize that 1-20% that they need for their business work flows.
Building a piece of software to work the way each and every organization wants is insane.
Imagine if Adobe Creative Cloud did this, nothing would be the same on any given piece of software.
-
Tryton
Use a Tryton partner as your developer. Something happens to that company you can use another one for modifications.The only trick is getting. A Business Analyst that understands the business and can communicate the requirements.
-
@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.
