Handling .JPE Image Extension

[Guest]

MS-ACCESS 2002 (10.6501.6714) SP3
I have the following Visual Basic Code that displays a picture from a file
location (usually .JPG, .GIF) and works fine within my form. However when I
try to display a .JPE file I get an error "Not supported by MS-ACCESS". I do
not want to use OLE Objects in the Data Table because these will grow my .MDB
significantly.

Me![PhotoImage_Label].Picture = FileLocation_and_Name

I have tried changing the file type in Windows Explorer to say paintbrush
etc. but the problem still persists with the above line of code.

Your help is greatly appreciated

Roberto

 

[Martin Walke]

Hi Roberto,

You'll need to convert the image into the standard JPG or GIF format.
Changing the extension or the file type won't do that. Access is telling
exactly the problem - it can't handle JPE extension types.

HTH
Martin

 

[Guest]

HI Martin,
Many thanks for your reply. I know I can do that but I cannot provide my
custoemr with a manual intervention on converting .JPE images after they have
captured them, even by batch or a detached process this is not acceptable.
I was hoping to do this with a filter or program at REALTIME. We are talking
about a Doctor's Surgery that takes hundreds of images a day and the OLYMPUS
Camera defaults to .JPG or JPE depending on quality and resolution. I cannot
force the Doctor(s) to always default to supported file type such as .JPG or
..GIF, that would be nice.

I still need a .JPE filter for MS-ACCESS at REALTIME. Why can't Microsoft or
someone allow this since .JPE is a reasonably well known supported Windows
File extension with most Digital Camera Software?

Many thanks

Roberto

 

[Martin Walke]

I see what your problem is. Is there not an ActiveX control somewhere that
will do the conversion on the fly?

Martin

HI Martin,
Many thanks for your reply. I know I can do that but I cannot provide my
custoemr with a manual intervention on converting .JPE images after they have
captured them, even by batch or a detached process this is not acceptable.
I was hoping to do this with a filter or program at REALTIME. We are talking
about a Doctor's Surgery that takes hundreds of images a day and the OLYMPUS
Camera defaults to .JPG or JPE depending on quality and resolution. I cannot
force the Doctor(s) to always default to supported file type such as .JPG or
.GIF, that would be nice.

I still need a .JPE filter for MS-ACCESS at REALTIME. Why can't Microsoft or
someone allow this since .JPE is a reasonably well known supported Windows
File extension with most Digital Camera Software?

Many thanks

Roberto

MS-ACCESS 2002 (10.6501.6714) SP3
I have the following Visual Basic Code that displays a picture from a file
location (usually .JPG, .GIF) and works fine within my form. However when I
try to display a .JPE file I get an error "Not supported by MS-ACCESS". I do
not want to use OLE Objects in the Data Table because these will grow my ..MDB
significantly.

Me![PhotoImage_Label].Picture = FileLocation_and_Name

I have tried changing the file type in Windows Explorer to say paintbrush
etc. but the problem still persists with the above line of code.

Your help is greatly appreciated

Roberto