Access with Pictures

[Lost101]

Hello.. I am trying to add pictures to my individual records. To explain
what I want to do,
I have an inventory table/form etc. When you scroll through the form
looking at each individual inventory item. I want to be able to see a picture
open and not something you have to click on to open.

Does anyone know how to do this? Any help would be greatly appreciated!!
Thanks...

 

[John W. Vinson]

Hello.. I am trying to add pictures to my individual records. To explain
what I want to do,
I have an inventory table/form etc. When you scroll through the form
looking at each individual inventory item. I want to be able to see a picture
open and not something you have to click on to open.

Does anyone know how to do this? Any help would be greatly appreciated!!
Thanks...

What version of Access are you using? Access2003 and earlier versions handle
pictures VERY inefficiently; the database will bloat to enormous size with
only a few pictures, and eventually reach the 2GByte database size limit and
fail. Access2007 is better but for large numbers of pictures (especially big
ones) you'll still have trouble.

One getaround is to store the pictures in a dedicated pictures folder with
systematic filenames (such as your inventory item ID, with a .jpg extension)
and store just the filename in your table.

 

[Lost101]

Thank you John. This answers my question perfectly! I am using 2003 and I
have been doing the Filename in my table method so I will continue to do
that. I appreciate your help!

Have a great day!
Tess