Inserting Pictures

[shaha]

Hello All,

I refer to this forum when building my databases and it has helped me a lot. Thank you.

I have searched for my issue but havent found what I was looking for, so I am creating this thread to ask my speacific question.

Background:

I have built a database where the users insert pictures into the form. I know by default Access only does .bmp files. You need to add additional code so .jpeg files can be added. I know if you embed the pictures the size of the DB will increase rapidly, so I am linking all my pictures.

I have a form that has a bound image object frame and the OLE Type Allowed property is set to Linked. The users right click the object and select insert object and browse to the location of the picture (.bmp) and select it, adding the picture to the form. If you select any other format other than .bmp, it shows up as an icon on the form. But if you select a .bmp format file than the image is displayed. I am ok with using .bmp.

Question:

The DB has been live for some time now and the size has grown to a 100MB. I am kinda nervous if the insert a link to the picture might not be working properly or if there is something else going on. One thing I have noticed is if I insert a picture via the method I mentioned above and I go and move the picture to another location, the picture still displays on the form and the path is also updated(OLE Edit Links). Is that normal? Also if I go and delete that picture completely, it still shows the picture on the form. Since it is doing that, I am thinking that the picture is actually attached and not linked.

Any ideas??

 

[ajetrumpet]

One thing I have noticed is if I insert a picture via the method I mentioned above and I go and move the picture to another location, the picture still displays on the form and the path is also updated(OLE Edit Links). Is that normal? Also if I go and delete that picture completely, it still shows the picture on the form. Since it is doing that, I am thinking that the picture is actually attached and not linked.

Any ideas??

check to see if the method is definately not EMBED. linked anything should result in an error if the source entity is not there. but, i could be wrong. also, not sure if this matters, but you might want to check the "type" property, to see if that changes any issues. i think the options are STRETCH, CLIP, and (ZOOM)

 

[shaha]

i open the form in design view and right click on the image object and properties....the OLE type allowed is set to Linked...the size mode is set to stretch.....i also looked at the field in the table...the type for the field on the table is OLE object....

 

[PaulWilson]

My goal is to embed a tiny bitmap image (i.e. thumbnail) and then link to the actual large file. IrfanView would be a good tool for batch reducing a large directory of files to a small defined size for use as thumbnails. My problem is that I don't have code that will limit the size of the thumbnail when the user tries to add it.