Sharing embedded images

[stev57]

I am using a large embedded image file as a background to several forms. Unfortunately it seems that the data is stored separately for every instance of this image, resulting in uneccessarily large file size for the entire database. Is there a way to share the image data between more than one form?

Also any general tips on reduding the size of embedded iamges would be useful (external files are undesirable).

 

[Access Hero]

This is a tough problem to overcome.

For the first part, just store the images in a database table via an OLE object. Microsoft has a nice writeup on that here:
http://office.microsoft.com/en-us/access/HP052802251033.aspx

To make them smaller, you need to convert them to a more compressed format (like jpg). There is a nice writeup on that here:
http://stackoverflow.com/questions/...cess-ole-objects-back-to-plain-jpegs-best-way

Alas, this is not for non-programmer types.