After you connect the N900 will have two buttons onscreen to push, one says mass storage" the other says "pc suite" (i think). You wont get access to the mass storage feature until you push the mass storage button.

As was also mentioned, if the phone is off, it defaults to mass storage mode, but since we NEVER turn our phones off, I thought this bit of info might be helpful!