[JDigital]

Most of the time with the "point and shoot" style cameras, where they fall short for aquarium photography is with their Macro abilities (or minimum focusing distance), as well as the limited range of shutter speeds. While most camera's may be in the 7-9MP department, the sensor on a p&s camera is alot smaller than the sensor in a Pro Body like Canon 40D/5D/Nikon D80/D300, therefore limited in its ability to replicate the quality of the more expensive cameras.

Here are a few samples from my Canon Powershot TX1. Untouched, straight off the memory card. I'd say they are fairly acceptable shots for most people.