If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to manage images (jpg or png small photos)?
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. |
#2
|
|||
|
|||
How to manage images (jpg or png small photos)?
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. |
#3
|
|||
|
|||
How to manage images (jpg or png small photos)?
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 "Nicola M" wrote in message ... 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. |
#4
|
|||
|
|||
How to manage images (jpg or png small photos)?
"Steve" wrote: 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 "Nicola M" wrote in message ... 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. 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?? |
Thread Tools | |
Display Modes | |
|
|