[AccessD]Error loading picture

Actually it is a bit more bizarre
You don't have to change the actual physical filename extension case.

Just change the filename string or just the extension part via UCase or 
LCase
when you pass to the Picture property of the Image control.

lower case bypasses Office Graphics filters, something to do with 
metafiles in the image.
If the file extension is in uppercase  then the Office Graphicsfilters 
will be used to load the image.

You can also download and install, if something has gone wrong with your 
filters.

Office File Converter Pack   OCONVPCK.EXE
This download provides file converters and image filters for Microsoft 
Office programs, from Microsoft Office 97 to Microsoft Office 2003.
It depends on what version of office is installed.

http://www.microsoft.com/downloads/details.aspx?FamilyID=cf196df0-70e5-4595-8a98-370278f40c57&DisplayLang=en

Info here
http://office.microsoft.com/en-us/assistance/HA011513581033.aspx

If you use Lebans method (a bit convoluted) to get .jpeg extensions make 
this change in Function fLoadPicture
 
Select Case right$(strfName, 3)

    Case "bmp", "dib", "Gif", "emf", "Wmf", "ico", "cur", "jpg", "peg"

I gave up using jpegs for other reasons, I was getting microfilm images
and so used djvu format as it can be up to 10 times smaller on black and 
white text type images
and has a text searchable metafile plugins. Some University libraries 
are using for historical
archive display on the web. Things like old manuscripts and folios.

http://www.djvuzone.org/wid/index.html
http://www.djvuzone.org/

Kath Pelletti wrote:

>Re: this problem:
>
>  
>
>>When the user opens a form which attempts to load a .jpg or .gif picture the system come up with "...the database doesn't support the format of 
>>'E:\Database\Photos\Peru.jpg' so it can't load the picture.
>>    
>>
>
>I found a bizarre solution in a line on the Lebans website to the effect that if the file extension is upper case it is treated differently by Access to it being in lower case. Disbelieving, I tried it and it works. If I change the file extension of the 350 photos which this system uses (which I can do with one DOS command) from .jpg to .JPG then Access manages to load them correctly.
>
>It's a bit of a bizarre solution but having uninstalled and re-installed the graphics filters for Office twice, then doing a complete re-installation of Office I am relieved to find any kind of a simple solution. 
>
>BTW - Marty - I did spend some tine on this:  http://www.lebans.com/loadjpeg­gif.htm but found that it was difficult to follow. Have you used it?  
>
>Kath
>
>______________________________________________
>Kath Pelletti
>Software Design & Solutions Pty Ltd.
>Ph: 9505-6714
>Fax: 9505-6430
>KP at SDSOnline.net
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada