I think it really depends on what is causing the pain.
I have used accupuncture for lower lumbar problems. While it makes me feel more comfortable for a brief period of time, it has no long-lasting effect...but my problems are structural so I don't see how it could help, long-term.
Also it is not a fast-acting treatment. It usually takes a course of treatment to even determine if it is going to help.
I have used accupuncture for other ailments and find it very interesting and enjoyable. If you haven't tried it, you might want to. It is very relaxing. Just be sure to go to someone who knows what they're doing and isn't trying to talk you into a long series of treatments, or a contract.