|
kmoorevs wrote: Who said anything about VBA?..or did I miss something?
I believe CodeWraith was alluding to the fact that many people who use Access use it because they can use VBA to manipulate it and then they think VBA is the best programming language ever and the associated issues with that.
As a matter of fact, why would anyone use Access if they don't use VBA? Well, I guess maybe because it's part of MS-Office.
|
|
|
|
|
Access leads to VBA, VBA leads to bad code, bad code leads to anger, anger leads to hate, hate ... to suffering and the Dark Side.
Ask any Jedi.
I am endeavoring, ma'am, to construct a mnemonic memory circuit using stone knives and bearskins.
|
|
|
|
|
CodeWraith wrote: By what I had to live through, Access itself is not the worst problem. The die hard VBA fans, their culture of tinkering and their typically less than brilliant workarounds are the problem. They have no clue why nobody else came up with such brilliant 'patterns' and feel quite insulted when you must tell them that they have built an unmaintainable mess.
Hmmm...I have worked in C, C++, Java, C#, Perl and SQL for decades. Certainly those that I have talked to suggest that JavaScript is similar.
And nothing suggests that any of those are chaos free.
So exactly which technology is chaos free?
|
|
|
|
|
You don't have to give me reasons to think that JavaScript is junk.
Still, the language is only a secondary problem. It's the culture of merrily hacking away without a plan or architecture and the myth that this is the one and only way to tackle everything. And when the day comes that the junk collapses under its own weight, then it's somehow your fault for pointing it out.
I honestly don't like to be called an idiot by people who never learned as much as I already have forgotten. Call me a snob, but I don't work in a place with such a culture. I know how it ends and having had the dubious pleasure once is enough.
I am endeavoring, ma'am, to construct a mnemonic memory circuit using stone knives and bearskins.
|
|
|
|
|
The Lounge[^]
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
It is a period of civil war. Rebel spaceships, striking from a hidden base, have won their first victory against the evil Galactic Empire.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Old misogynistic bugger feeling intellectually and professionally challenged by a younger (I assume) women starts bullying her.
She should report him to her manager (and/or HR); if they do not get involve, she should start looking for a better job.
I'd rather be phishing!
|
|
|
|
|
Oh jeeze, talk about throwing the old guy under the bus with 3rd hand comments. We could spin this another way - his wife may be dying of cancer, he was told by HR to train his replacement, and she's just a *itch.
I'm sure she's a nice person, I hope his wife is well, and he has a good job, but to start re-writing stuff on her second day there? Maybe time for a little coaching.
Charlie Gilley
<italic>Stuck in a dysfunctional matrix from which I must escape...
"Where liberty dwells, there is my country." B. Franklin, 1783
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
|
|
|
|
|
charlieg wrote: but to start re-writing stuff on her second day there? If one is not engaged exactly to do that, that's the best way to not pass the training time.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Yeah, right, the moron excuse is to always blame the woman.
I'd rather be phishing!
|
|
|
|
|
Yeah, right, the feminazi excuse is to always blame the man.
|
|
|
|
|
He is not blaming the woman, he is blaming the person that in the first day at work says the one in charge of the training "that's a crappy old fashioned thing and I can do better".
If a man had done it, my answer would have been exactly the same. If you are not hired to do exactly that, then shut the f*** up at least until you are in for some months
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Maximilien wrote: Old misogynistic bugger feeling intellectually and professionally challenged by a younger (I assume) women starts bullying her.
Description says that she was in a training class. Not an architecture meeting tasked with mapping out the future of the company.
And given it was a training class for MS Access I can only wonder what the intent of instructor and student was. As a student, I wouldn't suppose that myself I would actually need training on MS Access. It would be nice to be introduced to the layout but I most definitely would not be challenging the structure on the first day.
And I have been working with databases for more than 30 years.
Conversely as an instructor either the students are expected to have no knowledge or they are experienced professionals. With no knowledge then they should do nothing but learn. As experienced professionals they should already understand the nature of legacy applications and the intent of an introductory session. Neither of those types of students should be challenging the architecture.
|
|
|
|
|
jschell wrote: With no knowledge then they should do nothing but learn. As experienced professionals they should already understand the nature of legacy applications and the intent of an introductory session. Neither of those types of students should be challenging the architecture.
At least not until you are in enough time to understand the legacies, frames, history and have already built a name in the company.
I have re-built things a couple of times in projects that were going bad and ended faster than trying to fix the previous mess.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I started off application development with Access 2000 databases... badly...
I wrote some horrors in VBA that fortunately are no longer roaming the earth, as the company was folded(not due to my VBA I hasten to add).
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
I'm sure the general consensus here will be that Access is evil and should be avoided at all costs. I'll go against the grain here and just say that Access is simply another RDBMS that works perfectly well for small single user applications.
It may be old tech, but it works.
edit: I'm referring mostly to using Access as a database only, not for creating applications...I hate VBA as much as the rest of you!
"Go forth into the source" - Neal Morse
modified 6-Oct-17 9:09am.
|
|
|
|
|
I agree with you - I think Access is fine when used by experienced DBAs and experienced developers.
The problems arise when because of it's apparent ease of setup and use - inexperienced people start creating poorly designed databases with lots of VBA and other horrors that I did with Access databases.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
GuyThiebaut wrote: lots of VBA and other horrors that I did with Access databases I know exactly how you feel. We all have to get started somewhere and Access is that place for me as well. It's a good thing that I did not dwell there for too long. An experienced DBA took me under their wing to teach me all about SQL Server. They were a good teacher and one of the last few people to earn their SQL Server Master's Certification before Microsoft discontinued the program. That being said, I still cringe when people bring up Access. VBA isn't bad, per se, but you shouldn't be building applications with it.
Still, after leaning VBA, taking the next step to VB.Net was pretty simple. From there, I was able to draw on a lot of dabbling in C++ to make the leap to C#. Now I build entire applications from front to back on Windows and the Web. I guess you could consider me a multi-stack developer now
if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
|
|
|
|
|
kmoorevs wrote: I'll go against the grain here and just say that Access is simply another RDBMS that works perfectly well for small single user applications.
Exactly.
kmoorevs wrote: It may be old tech, but it works
Rather certain Oracle is older.
|
|
|
|
|
I'm an old guy and I'd be pissed if some newbie came in and started telling me how to do my job by fixing something that's not broken! I'd be even more pissed if they wasted my time by showing me examples!
"Go forth into the source" - Neal Morse
|
|
|
|
|
I can't disagree much. You don't show up at a new job and immediately start telling people they should redo everything using something you prefer, no matter what the pros and cons might be.
|
|
|
|
|
dandy72 wrote: You don't show up at a new job and immediately start telling people they should redo everything using something you prefer, no matter what the pros and cons might be.
To be fair those that are ignorant and inexperienced might do that.
|
|
|
|
|
So is this what happened here?
|
|
|
|
|
kmoorevs wrote: I'm an old guy Not as old as this guy[^].
It was broke, so I fixed it.
|
|
|
|
|
He has a point TBH. You can't "migrate" a col\row based database like Access to an hierarchical one like Mongo. Also it's not just the DB but the things that use it....they will need rewritten and retested. Also anyone who says Mongo is easier to maintain than Access would probably get fired on the spot if I had my way. And Mongo more secure? Didn't a whole bunch of companies get their data hacked because Mongo's default security is "off" so anyone can trawl the net for open ports and get what they want?
This sounds like fresh-out-of-uni idealism. You have to respect that in the real world we do have ties to old systems and things are done a certain way for a reason, and it's unlikely you'll appreciate that if it's your first day on the job.
|
|
|
|