Image field - help please

[David]

Hello,
I am trying to make a coin collection database which would have picture of
each coin (jpg images at 600dpi around 4x4 cm each). I have tried to
import image directly from a file, but this gives me a icon with field name,
which is not what I want I want to have a picture of the coin in the form.
The only way I have managed to do so is to import the image as a Photoshop
image, when Photoshop opens, I have to resize the "access image window" to
the resolution and size of the image (let say 4x4 cm and 600 dpi), then I
copy the image into the "access image window" flatten the image and close
it. This is the only way to import a picture into my record and had it
displayed in the form, it is rather work intensive and the resulting
database is very large (even though the original imnages are small in size)
has like 150 records and it is at the moment at 1Gb, which is not
acceptable, since it will have over 1000 records. Can somebody tell me
about a easier way to store pictures in the access database, these pictures
should be visible in the form, not just like"packages" or icons.

Thank you

David

 

[Roger Carlson]

The usual way is to leave the pictures in the file system and just store the
path to the file in the record. Then you can programmatically load the
picture into the form at run-time. It saves a lot of space in the database.

On my website (see sig below) is a small sample database called "Picture"
which illustrates how to do this.

 

[David]

Thanks for the tip, I will look into it, but I am not very strong on
programming

david