Struggling with Leg Ulcers: Seeking Advice

Hello! I'm a 43 year old female born and raised in the Northeast of England. This is my first post. I have a ton of health problems, but my worst lately are the leg ulcers. I've had them before, around 4 years ago, and 6 weeks in compression bandages healed them. This time, it's been almost 3 years since they appeared. After 36 separate treatments for a recurring infection, I'm now on a prescribed course of propholactic (long-term) antibiotics, 6 months of treatment has become 14 months and still taking them. Not only that, I still get infections that need extra treatment at least every other month. The compression isn't working. The pain relief (Oramorph) isn't helping at all, and I can't see them ever healing now. I've gained at least 2 stone due to immobility because of them. Has anyone had any positive results from light compression? Anyone had successful relief with a painkiller for them. If so, what is/was it? Thanks in advance.