Need help with photos on CD

[jdogrulz via AccessMonster.com]

Hi all,

This newbie needs some help please.

I need my db to be on cd for other cutomers. I have 4 cd's of photos that go
with it. My idea was to have the customer to start the db from a cd, then
browse through the records (1,400) and when they wanted to see a photo click
on a "show images" button. This would inturn open up my show_images form and
then would tell the customer to please insert the cd labeled "v5-N1" area,
and then the customer would insert this cd and presto, the photos would
appear. I am using DBPix. It works great just need to be portable with what I
have now..

any ideas?

Thanks much,

Jeff

 

[bob]

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).

 

[jdogrulz via AccessMonster.com]

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