The side door wont lock or unlock using any of the buttons
Ah well that's interesting! I used to drive a MK6 transit but my current ride is a '97 MK5 so I can't compare it directly. In the MK5 the central locking works all the doors together. The option to open just the rear doors is much better in my opinion. I have modified my own van to allow me to open the back doors independently but lock everything with one button.
How many contacts do you have on the door? I'd be suprised if all the contacts stopped working, they seem suprisingly reliable

. I'd check the connection inside the door. Of course cleaning the contacts is much easier so try that first! If you have an electrical test meter you can measure across the contacts to check if everything is as it should be. Without a diagram to hand I can't say what you should measure but you should see a change when you operate the lock/unlock.
No need to be depressed this is just a tiny problem that probably won't even cost you anything
Steve