My apologies to everyone in that I've not been back to this subject or even this forum for yonks.
I cured the issue, and it wasn't easy at all.
The gaffa tape on the roof stayed for a while and when I eventually peeled it off, it pulled the gel coat off the paintwork.
knowing what I know now, I'd have used some other method to get it off than just peeling it.
I wasn't sure where the water was getting in, but the gaffa tape had sorted it. I guessed that the water was getting in between the sunroof frame and the steel roof. I took off the inside trim, and removed the glass too, then I could see the sixteen nuts holding the frame down. I unscrewed them all but was careful not to remove them completely. The frame could then be prized up a tad, and I squirted silicone sealant in as far as I could. The frame lifted up ok, but the front portion wouldn't at all despite the nuts being undone, so the injection wasn't 100% but I hoped that it'd be fine.
It tightened everything down, replaced the glass, and cleaned up the excess silicone, and crossed my fingers.
Sadly, the silicone didn't work. As soon as we had a downpour, the water pooled in the footwells. I then put a poly sheet over the whole thing and gaffa taped it down. This was 100% successful but rather ugly to say the least, but it worked.
Months went by.
We don't have a garage, but our daughter has one, so I drove to her place, backed in, and set about taking the whole complete sunroof off. The Haynes manual tells you not to dismantle the sunroof, but I thought that I hadn't much to lose. I removed the glass, the inner trim, and all the sixteen nuts, and tried to lift it off. No joy, because the mechanism and motor system tucks under the roof between the roof lining and the steel roof. I disconnected the battery and managed to disconnect the electrics and undid the bolts holding the motor and the mechanism and with pulling and pushing lifted the sunroof system right out.
I went back home with Mrs Mick F in the other car and I started scratching my head about what to do next.
A week later, I went back with some black gutter sealant and white spirit and loads of rags. I cleaned off the silicone and also the original Renault sealant. Both of these were completely inadequate. The Renault stuff was black and hard and not fully all the way round, and not fully wide where the frame was. The Renault sealant was mainly on the frame and not on the steel very much at all. I made my mind up to do a FAR better job than Renault had done.
I re-fitted the frame dry to make sure I could do it and basically practice the operation. Then, with the frame off and upside down, I applied the gutter sealant all round and re-fitted the frame and squidged it down, and set about fitting the sixteen nuts. Not easy at all and it was a slow process. I used a ratchet ring spanner and the nuts could be placed into the spanner and offered up and screwed. 10mm spanner.
After fitting the motor and mechanism, I reconnected the battery and opened and closed the roof (without the glass) to make sure it worked ok. Then I cleaned off all the excess gutter sealant with white spirit, and finally fitted the sealing ring and glass.
This was all done during July of last year, and although we've had torrential rains, the car remains bone dry. That's nigh-on 12 months.
The one thing that I wasn't able to do, was connect the two rubber drain tubes. When you remove the frame, the tubes get pulled off and it's impossible to reconnect them. From what I can tell, the tubes allow the drainage from the frame ONLY when the roof is open, so the drains aren't required normally, and only if the roof is open when it rains. This would be if the roof was ajar when raining as you woudn't have it fully open in the rain!. As we hardly ever open the sunroof anyway, it isn't an issue to us.
If I were to live my life over again I wouldn't have used the gaffa tape idea at all, and gone straight to the roof removal method .......... but it takes some hours, so a covered area is the way forward ............ or if you can guarantee a rainless few days, do it in the open.
I hope that explains the story ok, and if anyone has any questions, please fire away and I'll try to answer them.
Best wishes to all,
Mick.