If you remove the CD that the database resides on then you can expect Access to have problems (‘Disk or
Network Error’, for example).  Otherwise, the user would have to swap CD’s to view a photo, then swap back
before scrolling to the next record – not very user friendly, and you would need to take care to pre-empt
any attempts to access the database in order to prompt the user to swap.

Possibilities:

1) Use a DVD, so that all the pictures fit on the same disk as the database.

2) Downsample the photos to screen resolution (and if necessary increase compression), so that they fit
on 1 CD (as long as you don’t need full resolution for zooming in or max quality printing).

3) Install the database to the hard drive so that it’s always available.

If you do need to span the files across CD’s then you’ll need to store info in the table to identify on
which disk each image resides.  Then, when trying to show an image, you should be able to check if the
file is found (with a Dir command), and if not you can prompt for the relevant disk.  

If the database is not launched from the CD you’ll need to find a way to identify the path to the images
(i.e. the drive letter of the CD drive).

--
_______________________________________________________
http://www.ammara.com/  
Image Handling Components, Samples, Solutions and Info
DBPix 2.0: Add pictures to Access, Easily & Efficiently

Thanks much for that Bob. Ur very correct on the cd thing. Thanks, that didnt
click in me head....dugh!..that just shows what a newbie i am. I thought
about using DVD but different computers use different media. U know what I
mean. Some + and some -  and the newer both wich is ok..but cant count on
customer having that..

Thanks again for everything Bob.

Jeff