How to manage images (jpg or png small photos)?

  • Thread starter Thread starter Nicola M
  • Start date Start date
N

Nicola M

Hi all.
Access 2003. I'm designing a DB for personnel management procedures. I need
to store a little photo of each individual. In your opinion is better to
store directly the image file as BLOB or only its path and manage the view of
the photo programatically?
Photos will don't change frquently.
Thank you in advance for advices, tricks and solutions.

Nicola M.
 
Storing images using an OLE field causes huge bloat and has other problems,
at least for all Access versions up through 2003. I heard that 2007 might
have fixed the problem but can’t vouch for that.

The way to do this is to store the pictures in a separate folder, and then
store the location (path) and filen name in 1 or 2 text fields. Then use
code to display the image in forms and reports. I’m not good enough to write
the “how to†from memory, but there have been many posts in the Access forums
on how to do that.
 
Steve said:
Add an image control from the toolbox for displaying your pictures. Select
the image control, open properties, find the picture property and bind it to
the path to your picture in your table as Fred describes.

Steve





Steve: I need to have a thumbnail photo (a very small .jpg) displayed in each record for my art inventory. If I can't figure out how to do this, I can't use Access which would be a big disappointment . I need to be able to scroll through the Database and SEE what's in there. Do you know hoe to do this? I can find no reference to this, and can't figure out how to do it. It's so easy in Word Tables, and Excel! What's going on with this software??
Click to expand...
 
Back
Top