I agree, hang in there with the Rowasa. (I posted a similar question this past week!)
If you are moderately flared or worse, it really seems to take 2-3 weeks to feel some results. My GI is very insistent that I do an enema at night AND again in the morning and hold for at least an hour to really attack the flare. But the morning regimine is tough - bowels must be empty and spasming/runs to the bathroom have to have stopped......THEN hold the enema for an hour and THEN go to work.
My GI recommends doing them for a month, even when sympoms have stopped, to stay on top of the inflammation.
Good luck!