The Cyber-shot DSC-W40 dates from 2006, part of Sony's early W-series line of simple, affordable compacts built for casual photographers who wanted point-and-shoot ease over manual features. It represents the CCD-compact era before touchscreens and video-centric designs took over.
It features a 6.1-megapixel 1/2.5-inch CCD sensor and a Carl Zeiss Vario-Tessar 3x optical zoom lens equivalent to roughly 38-114mm, with Sony's Super SteadyShot optical stabilisation. A 2.5-inch LCD handles framing, and images store to Memory Stick Duo cards, with power from an NP-BG1 lithium-ion battery.
Modest resolution and zoom range keep it firmly in entry-level territory, but the Zeiss-branded lens gives noticeably crisper results than many contemporaries at this price point, particularly in the centre of the frame in good light.
These sell cheaply as basic secondhand compacts or collector pieces from the mid-2000s. Verify the NP-BG1 battery still charges, check Memory Stick compatibility since SD cards are not supported, and test the zoom and mode dial for the stiffness common on units this age.