Robin, what are you trying to accomplish? In particular, what magnification do you want to work at?
Has anyone explained diffraction to you? At f/64 diffraction limits the best resolution possible in the center of the field to approximately 23 lp/mm. The best resolution possible off-axis is lower. At 1:1 and f/64 set, the effective aperture will be f/128 and the best resolution possible in the center of the field will be 12 lp/mm.
Why do you want to shoot at a tiny aperture? What problem do you think that will solve for you?
How are you going to light your subject? Electronic flash is possible if you're shooting single frame (animation). Otherwise you're stuck with continuous sources. I'm not familiar with the latest most best, so can't say anything.