Its a pretty simple and impossible problem to resolve.
On one side you have many law-abiding gun owners, many who will say to provide schools with armed police to protect them, and this will help bring down the violence. And they are absolutely right.
On the other side, you have people who will argue that without guns at all, most crimes like these wont be committed, and they too are absolutely right.
So everyone stands there and looks at each other and nothing gets resolved.
Its not like you see people shooting up police stations or army barracks. The attackers aren't that stupid. And sadly, we actually have people who are against armed police in schools by saying, "Well, I don't think we should have guns in school" which just sounds so ignorant. The reality is that the schools have been shown to be very vulnerable to repeat attacks, yet there seems to be this notion that if you think things shouldn't be a certain way, then they wont be.
The truth is, there just isn't enough outrage to change anything. People just say, "man, that's horrible, I hope it doesn't happen at my child's school" and move on. There just isn't enough people angry enough for change to elect people to congress to change the amendment. That's just the simple fact. And you don't have to be at school to be at the receiving end of gun violence. I had a guy pull a 357 on me from his truck and point it right at my head. I was 19 at the time. Strangely I wasn't freaked out then and looking back at it sort of have this, "it was what it was" attitude. There just doesn't seem to be anything that will be done about it for the foreseeable future, so you just kind of accept it.
Now keep in mind, banning automatic/bump stock assault weapons, which I am fine with, wouldn't have changed what happened to me. I doubt those will ever go away. And I like guns too. I don't have a problem with people owning them.
The law does virtually nothing to stop someone who really wants to shoot you. So if you can't rely on the law for protection, it looks like you have only one option: get a gun to defend yourself. The problem is how strict the law is regarding what can be considered self-defense when shooting someone, but that is a whole other can of worms to be opened.
To those outside of this country: we're still very much like in the Wild West. Very little has changed. Just instead of riding horses we use cars now. Anyone who thinks otherwise is fooling themselves.