El_Machinae said:
Hey, back onto the straw, I think I may have figured out what you were talking about. Here's a question to show if I understand.
The 40' drinker could pull water up the straw, as long as there is still water in the cup, right? Because the air pressure at ground level would still be 'pushing' down on the water surface at ground level. It's only once all the water is in the straw, that it gets tough, and the last bit is impossible. Am I right?
Close but no
It is not the vacuum in your mouth that sucks up the water, but the pressure of the surrounding atmosphere that forces water up the straw. The atmospheric pressure actually means "how heavy the air is." At ground level the atmospheric pressure is 15-ish pounds per square inch which means every square inch of ground has above it a column of air, stretching to the edge of space, which weighs 15 pounds.
Basically, on one end of the straw you have a vacuum and on the other end you have a constant 15 psi (pounds per square inch) of pressure. Thus, water wants to go up the straw. When the straw has some water in it, there are two forces at work at the opening of the straw. The first is that constant 15 psi
pushing up, and the second is the weight of the water that is already in the straw,
pushing down. Let's say your straw is exactly one square inch in diameter. Clearly, when your straw has 15 pounds of water in it, no more can go into the straw because the weight of the water already in the straw exactly counterbalances the atmospheric pressure. No matter how hard you suck, no water is going to go in that straw!

Instead of straws, think of scales. When the weight on each side is equal, the scale balances.
No matter what size straw you use, you will find that the atmospheric pressure will support no more than 15 pounds of water per square inch... or 10 meters or 34 feet, about.
Now to answer your other question, if you carefully sucked up just FOURTEEN psi of water into your straw, then took the straw out of the glass (being careful not to let the water escape from the straw), you could then suck those 14 psi of water up any height you like - all the way up the Empire State Building. As long as you are generating a vacuum in your mouth, the "scale" is not "balanced" and the water will move up the straw.