Vin is supposed to be connected to the positive lead on a battery or an ac adapter (wall wart), thus the 'in'. It's not supposed to supply power to your accelerometer. Please post your project pic.
I am new to arduino and electronics, so i am learning as i go. I will change the power to 3.3V. I don't have a camera to post pictures.