Save a picture to MS Access DB

[kyon]

Hi all,
Can I save a picture to the MS Access Database? How? I try to set the field type as OLE object. However, I don't know how to check it is really save the picture (*.gif), so I try to use mail merge function in MS Word 2000 to check the picture is correct or not. Unfortunately, it show me this "¤j«¬¤G¶i¨î¸ê®Æ©Î¤å¦r­È" as the picture. How can I solve this problem? In fact, I have to use the picture saved in the database to print label. Does anyone have this experience. Any suggestion is welcome.

Thank you very much!

kyon

 

[dhookom]

I would recommend against attempting to save images in tables. Your mdb file will grow astronomically fast. The method I use is to store the path and file name in a text field in the table. Then you can use the On Current event of a form or the On Format event of a report to load the image into an image control.

Duane
MS Access MVP

 

[kyon]

Hi Duane,
Thank you very much! Your suggustion is useful.
How can I extract the image in image control to print label function of MS Word 2000.

kyon

 

[dhookom]

Is there a reason that you don't create a label report in Access? I am not familiar enough with to describe how to load an image file.

Duane
MS Access MVP

 

[kyon]

I do not know how to create a label report in Access. I just know how to use print label function in MS Word. Can you tell me how to create the label report in access.

Thanks!

kyon