These four characters combine to create a powerful and literal image: seeing a crack and inserting a needle. This visual metaphor perfectly captures the essence of finding and utilizing even the most minuscule sliver of time, space, or weakness to one's advantage.
This idiom is extremely versatile and its connotation is heavily dependent on the situation and tone of voice.