I was inspired by all this to trot out the various macro setups I have (with extremely primitive lighting: mainly available light, though through large windows on two sides)...
report: Tamron SP 90 2.5 + 2x flat field converter: too long! Had to back way off to get a reasonably sized brooch fully in pic. Plus the whole thing's too heavy for my puny tripod.
Tamron SP 90 by itself: better! Reasonable working distance. However, I find manual focus with the K100D can produce unpredictable results. The in-focus flash in the viewfinder isn't always fully accurate. Flash integration with the K-A mount is decent though.
Super-Takumar 50/1.4 + extension tube. Similar focus problems as with the Tamron, and there's little flash automation (with my set up, with an auto thyrsistor controlled by the flash it should be better). The working distance is fairly close - a 12mm extension tube is sufficient.
Schneider Componon 35mm enlarger lens, held to the 12mm extension tube. This one surprised me, I was expecting a bit further focus... extreme close up, greater than life size, had to get pretty close to the subject. Nice results - I could see temporarily attaching this with bubble gum
without the tube for some fun.
Overall, I'm not overjoyed with the results - it was during the weekend nor'easter so light wasn't great, the tripod really is too puny - but it was fun. Thanks for the inspiration!
Samples of the main two setups:
http://farm3.static.flickr.com/2039/2117842482_3d1fe1a954.jpg
And the close up produced by the Schneider, these are tiny rhinestones
Based on this, I think a 50mm will give you a 6-10 inch working distance.