Re: Formula 1 Scam
From what I remember the big issue with Access was scalability - it's bloody dog-slow if you try to do more than a small businesses' worth of work on it. At one of my old gigs, an electronics manufacturing company, there were some 10,000 components set up in an Access database. Opening that, and making a change, and saving it could easily take 5 minutes. The other issue was access control, ironically, Access did not do that well. If two people were accessing the database, it became write-locked to protect it, and you might only find out when you went to 'save' your row. Usually you did have two engineers needing to update it, as well as stock management and goods in. So it all became a major pain in the arse.
It was ultimately superceded by an actual CRM system which was bought in with actual money rather than just a site licence for Access, but it did work without any major catastrophes like that for a good 15 years. Somehow.
Another company I worked for implemented their own CRM, which worked quite well. But napkin maths was it took one senior engineer about 6 months to do that with all the bells and whistles. It probably would have cost less to buy one in. But, it did integrate really nicely with the on-site production, the engineer had written interfaces to the pick and place machines so that every time an order went out it would automatically deduct all of that stock and a completed board would be registered in a new stock item once it left the oven. So it could be argued that it was worth the expenditure, since it was business critical.
The older I get the more I realise sometimes the best solution isn't the perfect one but the one that just works, it might be a bit slow or a bit expensive but if your £10m+ business depends upon it, then it had better work.