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.

[Stephen Lebans]

Re: Really ODD image loading error in Access 2003

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" <nospam@nospam. com> wrote in message
news:ag5k025pim r39k8m1s1t3qnr1 de7jl6s8f@4ax.c om...[color=blue]
> 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.[/color]

[Lauren Wilson]

Re: Re: Really ODD image loading error in Access 2003

On Sat, 04 Mar 2006 23:00:24 GMT, "Stephen Lebans"
<ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m> wrote:
[color=blue]
>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.[/color]

Somehow, I missed this. Go figure.
[color=blue]
>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?[/color]

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.

[Stephen Lebans]

Re: Re: Really ODD image loading error in Access 2003

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" <nospam@nospam. com> wrote in message
news:3gfk0215oj rcv23qja3892qrd 84odtq20r@4ax.c om...[color=blue]
> On Sat, 04 Mar 2006 23:00:24 GMT, "Stephen Lebans"
> <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m> wrote:
>[color=green]
>>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.[/color]
>
> Somehow, I missed this. Go figure.
>[color=green]
>>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?[/color]
>
> 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.[/color]