can anyone recommend a "female" spade connector which can screw on positively onto its "Male" attachment so that it does not come loose or impair its contact during in vibrating situations?
I have always found spades tight fitting but if they aren't then use pliers to squeeze the female connector a fraction then try connecting - should be a lot stiffer.
agree with all the above, if you are not splitting that often then a few turns of self-amalgamating tape around the spades will also help (but overkill imho) and will not leave a sticky residue