My Dog Keeps Crying

I have had to ban my dog from going upstairs in my house after she had several accidents on brand new carpeting.  She is not a puppy.  She is 9 years old and doesn't have accidents on the first floor of my house.  I had to put up a baby gate to stop her from going upstairs.  She used to sleep on my bed (upstairs) but has adjusted very well to sleeping downstairs.  However, during the day, if I have to go upstairs, she cries non-stop until I come back downstairs.  I have tried ignoring her.  I've tried strongly saying "no.'  I've even tried spraying her with water, something I thought I'd never do.  But she still cries when I go upstairs.  Any ideas of how to make her stop crying? I almost feel like a prisoner, unable to go upstairs in my own house.  Has anyone had success with the no bark collars or are they only for barking?