Displaying a .jpeg as linked OLE in a Form

[Walter Konopacki]

Having trouble displaying a jpeg in an Access 2003 form. Have read in Access Forms Dummy Book the an anomaly is present in Access 2003 that does not allow JPEG images to be displayed because Office 2003 does not include MIcrosoft Photo Editor. It says I need to convert the file to a BMP or DIB. Has anyone had this problem and is there anyway to work around it. Coverting my photos is just more work I would like to avoid.

[missinglinq]

You might have a look at this site:

http://www.ammara.com/articles/access-jpg.html

The DBPix program mentioned has a good reputation.

Welcome to TheScripts!

Linq ;0>

[FishVal]

Hello, Walter.

You may find a solution in The BLOB (not the movie!) article.

Regards,
Fish

[sierra7]

Hello again Walt

I see you are having problems displaying pictures. I've heard about this problem and read the Microsoft kb article about Access 2003

However my Access 2003 computer displays graphics OK for me and does not have Photo Editor (photoed.exe) anywhere on any-drive. If I double click an graphic file either BMP or JPG it's displayed in something called 'Windows Picture and Fax Viewer'

I can display picture ok using an Access Unbound Image Control. In the On_Current event of the form I load the image using ;-

If Me!GPath <> "" Then Me!Image8.Picture = Me!GPath

where GPath is a textbox holding the path and filename of the graphic and Image8 is the name of the image control.

There may be an issue with a Graphics Loading Bar displaying momentarily when loading jpgs but a registry fix from this reference will stop it.

The disadvantage of using this method as everybody will tell you is that path to the graphic is stored in the database, so if the location is changed the picture can not be displayed. Surprise! But at least the graphics do not bloat the database.
S7