Most of you are probably aware of the basic idea of liquid thread locking compounds.
"Red" - High strength for medium to larger bolts most people will run across.
"Blue" - Medium strength for the mid size and smaller bolts most people will run across.
Until I ran across needs that was about the limit of what I knew. I expect most non professional mechanically inclined people start there.
The next one I ran across was "Green" which was a sleeve and bearing locker. I used it on a "press" fit hose fitting on a pickup truck engine I was working on. Probably in my early 20s.
Then later I discovered "Purple" which is a light thread locker. I used it on fishing reel components I still wanted to be able to get apart without heating up small parts that probably can't take the heat not even accounting for plastic parts nearby.
Then I started learning that the colors were just a rough guide, and that there were various formulas for special applications. Steam fittings, thread sealers, etc. Yes, still talking about "thread lockers" formulations here.
A while back I was working on an air rifle (real small game power) which use a pair of set screw to restrict airflow and regulate power. One was turned into a hole that crossed the air passage until reaching the desired power/velocity, and the other back stopped the first to "lock" it in place. The back stop didn't always work. The answer was VC3 from Vibratite. Its a non locking thread locker. Its supposed to prevent a a screw (or other threaded item) from moving from vibration, but allow it to move using a tool and not need to be reapplied for many cycles. It was perfect for dialing in that air gun flow restricter. Then I just set it and forget it. I did gently put in the back stop screw, but the VC3 kept the screw in place through a few days of adjusting and tweaking to get just the power and velocity I was looking for.
On my big (for me) manual mill (10x54 table, 5hp, 16x36 travels) I almost never use the dials on the hand wheels, but they have threaded collars that snug them in place when using them. Less damaging I suppose than set screws, but they have a problem. They back off on their own over time. I've gone so far as to snug them down with a pair of slip joint pliers. I find them to be awkward and in the way sometimes. On the knee it activates the safety switch and prevents me from powering up or down the knee. I don't want to get rid of them, because I do know how to machine using the hand wheels and not that long ago one of my DRO scales flaked out. I had to use the hand wheels to do some work until I fixed the DRO.
Do you think a couple drops of VC3 on the threads of those locking collars would be a good idea?
I'm not sure how much force would be required to move them, but I suppose I could drill a hole, and use a spanner if its more than my hand strength. The spanner for my keyless chuck (which is always right there) might be made to work.