Find the cause
Vicodan or other narcotics are really only indicated for short term treatment, not long term "relief".
Find the root cause and treat it (break the cycle). Start with imaging
, then less invasive treatment such as injections, and finally consider surgery if indicated. Above all go to a reputable doctor who has an interes tin diagnosing your condition rather than just treating or masking the pain.