Really ODD image loading error in Access 2003

Lauren Wilson

Hi folks,

we have an Access 2003 app that is running just fine on several
thousand computers all over North America. Recently, on ONE in
particular, we suddenly started see a startup error, something like:

"Unable to load JPEG. Image too large. Try a BMP of GIF format
instead." The JPEG in question is just an image for the Title screen.
The file is 335 KB and is loaded at runtime by VBA code by setting the
form's "Picture" property to the full path name of the JPEG file.

We have no such problem on ANY other computer running the same code
(that I know about), and we cannot recreate the error on any of our
development machines.

The computer in question is a Dell, it's only 3 months old, and does
NOT have any version of Microsoft Office installed. All it has is our
app and a copy of Access 2003 Runtime.

Is it possible this error relates to missing graphics filters and
converters that can be installed with Office?

Any advice on this would be most appreciated.

Mar 4 '06 #1

Stephen Lebans

There is nothing odd about your issue. It is a well known documented that
Runtime only installs, on systems without any Office apps installed, do not
have the ability to use the Office Graphics filter DLL's.

With a surch a large distribution of your app, in a Runtime configuration,
why wouldn't you have simply embedded the JPEG, either directly within an
Image control or a table?
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Lauren Wilson" <no****@nospam.com> wrote in message
news:ag********************************@4ax.com...

Hi folks,

we have an Access 2003 app that is running just fine on several
thousand computers all over North America. Recently, on ONE in
particular, we suddenly started see a startup error, something like:

"Unable to load JPEG. Image too large. Try a BMP of GIF format
instead." The JPEG in question is just an image for the Title screen.
The file is 335 KB and is loaded at runtime by VBA code by setting the
form's "Picture" property to the full path name of the JPEG file.

We have no such problem on ANY other computer running the same code
(that I know about), and we cannot recreate the error on any of our
development machines.

The computer in question is a Dell, it's only 3 months old, and does
NOT have any version of Microsoft Office installed. All it has is our
app and a copy of Access 2003 Runtime.

Is it possible this error relates to missing graphics filters and
converters that can be installed with Office?

Any advice on this would be most appreciated.

Mar 4 '06 #2

Lauren Wilson

On Sat, 04 Mar 2006 23:00:24 GMT, "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote:

There is nothing odd about your issue. It is a well known documented that
Runtime only installs, on systems without any Office apps installed, do not
have the ability to use the Office Graphics filter DLL's.
Somehow, I missed this. Go figure.
With a surch a large distribution of your app, in a Runtime configuration,
why wouldn't you have simply embedded the JPEG, either directly within an
Image control or a table?

Well ... the intention was to make that single image available
anywhere we needed it in the program while installing only one copy of
the image. I suppose we COULD accomplish the same thing by storing
the image in a table and just grabbing it as needed. Thanks for the
tip. As usual Stephen, you are an amazing asset in this group.

Mar 5 '06 #3

Stephen Lebans

If you do not want to modify your current distribution the see:
http://www.lebans.com/loadjpeggif.htm
Scroll down to the older non GDI+ plus versions here:
A97LoadJpegGif.zip is a database containing a function to allow for the
Display of Jpeg and Gif files on systems that do not have the Office Graphic
Filters installed. Here is the A2K version: A2KLoadJpegGif.zip
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Lauren Wilson" <no****@nospam.com> wrote in message
news:3g********************************@4ax.com...

On Sat, 04 Mar 2006 23:00:24 GMT, "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote:

There is nothing odd about your issue. It is a well known documented that
Runtime only installs, on systems without any Office apps installed, do
not
have the ability to use the Office Graphics filter DLL's.

Somehow, I missed this. Go figure.

With a surch a large distribution of your app, in a Runtime configuration,
why wouldn't you have simply embedded the JPEG, either directly within an
Image control or a table?

Well ... the intention was to make that single image available
anywhere we needed it in the program while installing only one copy of
the image. I suppose we COULD accomplish the same thing by storing
the image in a table and just grabbing it as needed. Thanks for the
tip. As usual Stephen, you are an amazing asset in this group.

Mar 5 '06 #4