The fob unlock doesn't work either. So now I'm not sure whether it's the solenoid or the Body Computer. The solenoid is $280 for the part, probably 1 hour labor, so I am looking at a $400 repair before it's done. Do you think those parts are available used or in a junk yard?It could either be the switch itself or the solenoid that activates the door lock mechanism. However, assuming your passenger side switch works fine, it's likely the switch. You might try swapping the two switches to see if that's the case.
And, it might just be a loose connection between the switch and the harness plug.