This happened to me today on my '04 Z4. Only had the car a short while, I know that the history was that the previous owner passed away so the car was stationery for a while.
Had been out for a sunny drive today, parked up in a pub for an hour with the roof still down and locked car. Got in the car for the drive home about an hour later and central locking didnt work. The remote would lock the car and unlock the boot, but first the passenger side started playing up (wouldnt unlock) then the drivers too. Old fashioned key in the lock worked, but only for the driver, passenger still stuck. This resulted in my missus having to get in the drivers side and rather unglamorously hoik herself over the central console. Not good in a short summer dress!
Anyway, came home, tried a few things. Got it working for a while, then it stuck again. As I said locking the car and the boot release worked a treat. Trawled the forum and saw a few scare stories about how much BMW charged to repair. Had one last thought. Had some ASSA oil (locksmiths oil, much finer than WD40) in the garage. Squirted a bit in the lock button plunger, the handle (inside) and the key hole. In a few seconds passenger door was open and the whole system worked perfectly.
Now I might have got well lucky here so I will keep you posted if it plays up again. But worth a try if it happens to you.
Had been out for a sunny drive today, parked up in a pub for an hour with the roof still down and locked car. Got in the car for the drive home about an hour later and central locking didnt work. The remote would lock the car and unlock the boot, but first the passenger side started playing up (wouldnt unlock) then the drivers too. Old fashioned key in the lock worked, but only for the driver, passenger still stuck. This resulted in my missus having to get in the drivers side and rather unglamorously hoik herself over the central console. Not good in a short summer dress!

Anyway, came home, tried a few things. Got it working for a while, then it stuck again. As I said locking the car and the boot release worked a treat. Trawled the forum and saw a few scare stories about how much BMW charged to repair. Had one last thought. Had some ASSA oil (locksmiths oil, much finer than WD40) in the garage. Squirted a bit in the lock button plunger, the handle (inside) and the key hole. In a few seconds passenger door was open and the whole system worked perfectly.

Now I might have got well lucky here so I will keep you posted if it plays up again. But worth a try if it happens to you.