I'd definately store the image on your drive somewhere and reference
it from the application. It's very easy to do this and will end up
being far quicker and won't bloat the db. I've done that on one of my
apps (link below) and can give you some code to help if you need it.
You can use FileSystemObjec ts to handle copying the images to the
correct directory if it makes things easier, and then only show the
image when you view the current record.
Oh, and look out for the registry setting if you keep getting an
annoying pop up box (and progress bar) saying that it is importing the
image, you can turn it off quite easily. I can't get to the registry
on my work's PC, but I think it's
HKEY_Local_Mach ines\Software\M icrosoft\Graphi cs Filters\Jpeg\Op tions\
set show dialog to No (if I remember correctly).
Best of luck.
Ryan
http://www.ryan.dial.pipex.com