Non JPG Image file extension

[Guest]

I have a folder with over 100,000 images I would like to link to records in
an Access Database. The only problem is the images have a file extension of
..001 that can not be changed. I need to get Access to recognize this file
extension as a JPG file. Is there any way to do this?

 

[kingston via AccessMonster.com]

A possibility is to copy the .001 file to a temporary .jpg file and have
Access work with the temporary file. Assuming that you are displaying the
images in an Access image control (one at a time), use the On Current event
and this:

FileCopy "FilePath\File.001", "NewFilePath\NewFile.jpg"
Me.Control.Picture = "NewFilePath\NewFile.jpg"

 

[bob]

IIRC, the graphics filters (used to display external image files in the Access Image Control) are very
specifically tied to file extensions. You might be able to hack around in the registry to associate the
JPEG filter with additional extensions.

You could also try Stephen Lebans solutions, using either the GDI+ dll or the Intel JPEG library, at http://www.lebans.com

Finally, some commercial components, including our own DBPix image control, interpret the image correctly
according to content rather than file-extension.