view picture objects

[zayan Kab]

Hi,
I have a problem in inserting pictures as objects in a database field (an
OLE Object Field).
I was able to insert the pictures only in .psd format in a system having the
following characteristics: XP/Office2007
I was able to insert the pictures only in .bmp format in a system having the
following characteristics: Vista/Office2007
The database will be used in a system "Vista Home premium"/"Office 2007
french", for this system I tried all the pictures formats but I was not able
to view any of them. Always an Icon replaces the picture even if it is set in
the properties of the field to insert the content not the icon.

Thanks for your help

 

[Tom Wickerath]

Access 2007 is the first version of Access that allows one to embed images
without suffering severe file bloat, but one must use the newer .accdb file
format, with an option set that does not allow downconverting the database at
a later time to, say, Access 2003 or earlier.

My recommendation is to just store the full path to the image instead of
trying to store the image itself. Yes, it takes some VBA code to do this, but
it's not all that difficult. Here is an example:

http://www.accessmvp.com/TWickerath/downloads/ImageDemo.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________