problem with linking pictures

[zayan Kab]

Hello,
I have a problem with inserting pictures as objects in the database:
I am able to insert these pictures if working on XP/MSOffice2007 if the
format of the picture is only PSD.
when using Vista/MSOffice 2007 the picture is inserted but if the format is
just bmp.
When using Vista Home premium/MSOffice2007 (the office is French version) I
always have the icon not the content of the picture. I tried all the possible
formats but I always had the icon (I have set in the field properties that I
want it to inset the content not the icon). The database that I am conceiving
is dedicated for the system using Vista Home premium/MSOffice2007 (the office
is French version).

Thanks for your cooperation

zayan

 

[strive4peace]

Hi zayan,

instead of using an OLE control, try this:

make a field to hold the file path and name as text data type

on your form, use an Image control (mountains with sun icon) and specify
its ControlSource to be the field containing the file path and name

Image controls handle a wider variety of file types

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Fred]

Until this situation possibly changed with Access 2007, storing the file/path
(as Chrystal described) rather than embedding/OLE link was the ONLY viable
way. And I'd still consider it to be the best way.

Sounds like you can also fix your problem by upgrading your Vista to SP.

Personally, I'd do both.

 

[Tony Cottle]

Hello,
I have a problem with inserting pictures as objects in the database:
I am able to insert these pictures if working on XP/MSOffice2007 if the
format of the picture is only PSD.
when using Vista/MSOffice 2007 the picture is inserted but if the format
is
just bmp.
When using Vista Home premium/MSOffice2007 (the office is French version)
I
always have the icon not the content of the picture. I tried all the
possible
formats but I always had the icon (I have set in the field properties that
I
want it to inset the content not the icon). The database that I am
conceiving
is dedicated for the system using Vista Home premium/MSOffice2007 (the
office
is French version).

Thanks for your cooperation

zayan