By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Graphics in image control (Access97)

P: n/a
I have an app for a client (Access97, all the final service releases
and Jet service packs, full installation (not runtime)), that
displays a graphic in an image control based on a path/filename
stored in a field in a data table. It works just great on my PC for
BMP, GIF and JPG.

But on the client's PC, JPG doesn't work (dunno if GIF works or not
-- didn't try it; BMP does work).

I wrote to Larry about this and he hasn't any suggestions to offer.

Any ideas as to what I should look at?

I note that if if use the Access file open to insert the file name
for the picture into the property sheet, the extensions in the FILES
OF TYPE dropdown do not include GIF or JPG.

Yet, Word has no difficulties inserting a JPG.

Is this yet another of the problems with Office Small Business
Edition (in this case SBE 97 + A97)?

Any suggestions?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
Hi, David.

Have the client install the graphics filters for JPEG's, GIF's and any other
graphics files they think they might need from their Microsoft Office 97 Pro
installation CD. The client probably didn't do a custom install to include
all of these goodies for Access on his computer. (Perhaps Word, but not
Access.)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn*********************************@216.196.9 7.142...
I have an app for a client (Access97, all the final service releases
and Jet service packs, full installation (not runtime)), that
displays a graphic in an image control based on a path/filename
stored in a field in a data table. It works just great on my PC for
BMP, GIF and JPG.

But on the client's PC, JPG doesn't work (dunno if GIF works or not
-- didn't try it; BMP does work).

I wrote to Larry about this and he hasn't any suggestions to offer.

Any ideas as to what I should look at?

I note that if if use the Access file open to insert the file name
for the picture into the property sheet, the extensions in the FILES
OF TYPE dropdown do not include GIF or JPG.

Yet, Word has no difficulties inserting a JPG.

Is this yet another of the problems with Office Small Business
Edition (in this case SBE 97 + A97)?

Any suggestions?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #2

P: n/a
Oops. Wrong CD version. Should read: Access 97 CD, not Office 97 Pro CD.

The client still needs to do the "Custom" install, not "Typical" install to
get these graphics filters installed.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:Oqs4d.556$Jj4.146@trnddc06...
Hi, David.

Have the client install the graphics filters for JPEG's, GIF's and any other graphics files they think they might need from their Microsoft Office 97 Pro installation CD. The client probably didn't do a custom install to include all of these goodies for Access on his computer. (Perhaps Word, but not
Access.)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn*********************************@216.196.9 7.142...
I have an app for a client (Access97, all the final service releases
and Jet service packs, full installation (not runtime)), that
displays a graphic in an image control based on a path/filename
stored in a field in a data table. It works just great on my PC for
BMP, GIF and JPG.

But on the client's PC, JPG doesn't work (dunno if GIF works or not
-- didn't try it; BMP does work).

I wrote to Larry about this and he hasn't any suggestions to offer.

Any ideas as to what I should look at?

I note that if if use the Access file open to insert the file name
for the picture into the property sheet, the extensions in the FILES
OF TYPE dropdown do not include GIF or JPG.

Yet, Word has no difficulties inserting a JPG.

Is this yet another of the problems with Office Small Business
Edition (in this case SBE 97 + A97)?

Any suggestions?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


Nov 13 '05 #3

P: n/a
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:Oqs4d.556$Jj4.146@trnddc06:
Have the client install the graphics filters for JPEG's, GIF's and
any other graphics files they think they might need from their
Microsoft Office 97 Pro installation CD. The client probably
didn't do a custom install to include all of these goodies for
Access on his computer. (Perhaps Word, but not Access.)


The client didn't do the install -- I did.

And I checked that, even doing a re-install of Word to get the
graphics files installed. Didn't work. So, I tried uninstalling, and
that didn't work either -- the filters were still listed as
installed.

This is why I assume it's a SBE problem.

I hesitate to muck up their installation with Office Pro. I guess
I'll have to completely uninstall everything and re-install.

What a pain.

Why can't MS make their products work?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

P: n/a
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:nxs4d.559$Jj4.244@trnddc06:
Oops. Wrong CD version. Should read: Access 97 CD, not Office
97 Pro CD.

The client still needs to do the "Custom" install, not "Typical"
install to get these graphics filters installed.


I couldn't find graphics filters on the A97 CD, but then again, I
now remember that I had a problem with finding them for Word, as
well (it's under the Filters category, or something like that).

I'll have to check that yet again next time I'm there.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #5

P: n/a
Hi, David.
(it's under the Filters category, or something like that).
It's a check box for "Converters and Filters" on the Office 97 Pro Installer
for the "Custom" install. I imagine it's the same for the Access 97 CD,
too, but I don't know for sure.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142... "'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:nxs4d.559$Jj4.244@trnddc06:
Oops. Wrong CD version. Should read: Access 97 CD, not Office
97 Pro CD.

The client still needs to do the "Custom" install, not "Typical"
install to get these graphics filters installed.


I couldn't find graphics filters on the A97 CD, but then again, I
now remember that I had a problem with finding them for Word, as
well (it's under the Filters category, or something like that).

I'll have to check that yet again next time I'm there.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #6

P: n/a
Hi, David.
The client didn't do the install -- I did.
Excellent. Then you know that it's best to do the "Custom" install with all
the bells and whistles, not the "Typical" install, which leaves users
hunting for functionality later, only to find that the feature they need
wasn't installed and they have no idea where that CD went to, nor what the
product key was, either.
And I checked that, even doing a re-install of Word to get the
graphics files installed. Didn't work. So, I tried uninstalling, and
that didn't work either -- the filters were still listed as
installed.
I just tested an uninstall of Office 97 on one of my computers. Looks like
everything except the product key is still sitting there. Not much of an
"uninstall," is it?
This is why I assume it's a SBE problem.
You're probably right, but perhaps it's an application integration issue,
too. I've always heard it's best to get the entire Office suite -- instead
of piecemealing it together with additions of individual applications -- in
order to have the best chance for a successful integration of the products
if future plans are to get most, if not all, of the suite anyway.

Getting the SBE for Microsoft Office 2003 is even worse for those businesses
who think they may want to take advantage of the .Net Framework. Visual
Studio Tools for Microsoft Office 2003 can only build .Net solutions for the
Excel version contained in the Office 2003 Pro or standalone Excel 2003
versions, so these businesses will need to purchase more software. That's
more than they bargained for when they decided to go with the SBE version,
because most have the expectation of future expansion of their office
productivity suite without having to upgrade.
Why can't MS make their products work?
You've heard of "planned obsolescence" in motor vehicles? It's like
"built-in obsolescense" in software. Microsoft makes money when customers
purchase new versions. If the current version works great, why would
customers need (or purchase) anything more?

Good luck to you.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142... "'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:Oqs4d.556$Jj4.146@trnddc06:
Have the client install the graphics filters for JPEG's, GIF's and
any other graphics files they think they might need from their
Microsoft Office 97 Pro installation CD. The client probably
didn't do a custom install to include all of these goodies for
Access on his computer. (Perhaps Word, but not Access.)


The client didn't do the install -- I did.

And I checked that, even doing a re-install of Word to get the
graphics files installed. Didn't work. So, I tried uninstalling, and
that didn't work either -- the filters were still listed as
installed.

This is why I assume it's a SBE problem.

I hesitate to muck up their installation with Office Pro. I guess
I'll have to completely uninstall everything and re-install.

What a pain.

Why can't MS make their products work?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #7

P: n/a
"David W. Fenton" <dX********@bway.net.invalid> wrote in message news:<Xn*********************************@216.196. 97.142>...
I have an app for a client (Access97, all the final service releases
and Jet service packs, full installation (not runtime)), that
displays a graphic in an image control based on a path/filename
stored in a field in a data table. It works just great on my PC for
BMP, GIF and JPG.

But on the client's PC, JPG doesn't work (dunno if GIF works or not
-- didn't try it; BMP does work).

I wrote to Larry about this and he hasn't any suggestions to offer.

Any ideas as to what I should look at?

I note that if if use the Access file open to insert the file name
for the picture into the property sheet, the extensions in the FILES
OF TYPE dropdown do not include GIF or JPG.

Yet, Word has no difficulties inserting a JPG.

Is this yet another of the problems with Office Small Business
Edition (in this case SBE 97 + A97)?

Any suggestions?


Hi David,

Had the same problem 2 years ago and raised it in the NG,
unfortunately no reply.

What I found out is that it must have something to do with the O/S
and/or memory. Had the problem in my Acc 97 app on a PC with Win 98
SE, memory at that time was 128 MB. The same picture was shown
correctly on another PC with Acc 97, WIN NT and 256 MB memory.

To the users of my application I have recommended to using gifs which
worked fine.

Don't know whether jpg's now work under Win XP, haven't tested it.

Regards,
Sabine
Nov 13 '05 #8

P: n/a
On Thu, 23 Sep 2004 15:45:08 -0500, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:Oqs4d.556$Jj4.146@trnddc06:
Have the client install the graphics filters for JPEG's, GIF's and
any other graphics files they think they might need from their
Microsoft Office 97 Pro installation CD. The client probably
didn't do a custom install to include all of these goodies for
Access on his computer. (Perhaps Word, but not Access.)


The client didn't do the install -- I did.

And I checked that, even doing a re-install of Word to get the
graphics files installed. Didn't work. So, I tried uninstalling, and
that didn't work either -- the filters were still listed as
installed.

This is why I assume it's a SBE problem.

I hesitate to muck up their installation with Office Pro. I guess
I'll have to completely uninstall everything and re-install.

What a pain.

Why can't MS make their products work?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


As I remember it the graphic filters used to show an ugly progress
bar as a jpeg image was loading. Maybe modern pcs are too fast to see
this. Steve Lebans had a better image display package for A97 on his
web site.
David Schofield

Nov 13 '05 #9

P: n/a
"David Schofield" wrote
Steve Lebans had a better image display package for A97 on his
web site.


That is an excellent suggestion. I am mentally slapping myself "upside the
haid" for not thinking of Stephen's http://www.lebans.com as a source,
specifically http://www.lebans.com/loadjpeggif.htm.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #10

P: n/a
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:HRO4d.11317$2A1.8812@trnddc08:

[]
This is why I assume it's a SBE problem.
You're probably right, but perhaps it's an application integration
issue, too. I've always heard it's best to get the entire Office
suite -- instead of piecemealing it together with additions of
individual applications -- in order to have the best chance for a
successful integration of the products if future plans are to get
most, if not all, of the suite anyway.


Well, I haven't really seen that, to be honest, but I haven't dealt
with any version of SBE since 97. Well, clients have bought it
pre-installed on Dell PCs, but we've immediately ripped it out and
replaced it with their old SBE 97.
Getting the SBE for Microsoft Office 2003 is even worse for those
businesses who think they may want to take advantage of the .Net
Framework. Visual Studio Tools for Microsoft Office 2003 can only
build .Net solutions for the Excel version contained in the Office
2003 Pro or standalone Excel 2003 versions, so these businesses
will need to purchase more software. That's more than they
bargained for when they decided to go with the SBE version,
because most have the expectation of future expansion of their
office productivity suite without having to upgrade.


I don't know about later versions of SBE, but SBE 97 is a disk with
the installers for the standalone products, not an integrated
installer at all.
Why can't MS make their products work?


You've heard of "planned obsolescence" in motor vehicles? It's
like "built-in obsolescense" in software. Microsoft makes money
when customers purchase new versions. If the current version
works great, why would customers need (or purchase) anything more?


I don't know what to think about this one. It's unlikely to be an OS
problem, because I'm using the exact same OS (well, Win2K SP3 vs.
their SP4).

Today at a client's I struggled to try to figure out why a report in
A97 crashes A97 as soon as it's previewed on WinXP. On the client's
other PC, which is Win98, the report run from the identical MDB
works just fine. It's clearly something about the interaction of the
data source and the report, but I can't figure out exactly what (the
query the report is based on runs fine; the report without a
recordsource runs fine). I suspect it's something in the
sorting/grouping, but since the client uses the report rarely and
can print it from the other PC, it wasn't worth investigating.

I don't like getting paid to investigate problems that are clearly
caused by Microsoft.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #11

P: n/a
d.***************@blueyonder.co.uk (David Schofield) wrote in
news:415421c7.61368152@localhost:
As I remember it the graphic filters used to show an ugly
progress bar as a jpeg image was loading. Maybe modern pcs are too
fast to see this. . . .
It is certainly not worth worrying about on my PC, which is hardly
modern (a 1999 500MHz).
. . . Steve Lebans had a better image display package for A97 on
his web site.


I'll see if that will do the trick.

I hope, I hope, I hope!

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #12

P: n/a
Sa*************@unilever.com (Sabine Oebbecke) wrote in
news:5c**************************@posting.google.c om:
Had the same problem 2 years ago and raised it in the NG,
unfortunately no reply.

What I found out is that it must have something to do with the O/S
and/or memory. Had the problem in my Acc 97 app on a PC with Win
98 SE, memory at that time was 128 MB. The same picture was shown
correctly on another PC with Acc 97, WIN NT and 256 MB memory.
It can't possibly be a memory issue -- the client's PC has more RAM
than mine.
To the users of my application I have recommended to using gifs
which worked fine.
Well, these graphics are part of their web page, and will be
uploaded to their web page, and GIF is not an appropriate format for
them (these are photographic images). It has to work with JPG, no
ifs ands or buts.
Don't know whether jpg's now work under Win XP, haven't tested it.


In this case, it's Win2K on both my development machine and on both
the clients' PCs. That's a thought -- I didn't try it on their
laptop.

But I'm going to try implementing Steve Lebans' replacement and see
if that solves the problem.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #13

P: n/a
Bri
Larry,

Stephen's methods look like he calls the GDI+DLL directly. Is this the
same GDI+DLL that is the victim of the latest exploit? If so, then it
would be a good idea to get the post-patch version of it. More info at:

http://www.symantec.com/avcenter/sec...ent/11173.html

http://www.microsoft.com/technet/sec.../ms04-028.mspx

Bri

Larry Linson wrote:
"David Schofield" wrote

Steve Lebans had a better image display package for A97 on his
web site.

That is an excellent suggestion. I am mentally slapping myself "upside the
haid" for not thinking of Stephen's http://www.lebans.com as a source,
specifically http://www.lebans.com/loadjpeggif.htm.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #14

P: n/a
The GDI+ solution is only required if you need to support TIF files. If
not then use the older LoadJpegGif solution as it is well tested and in
widespread use.
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Bri" <no*@here.com> wrote in message
news:fcX5d.123688$%S.43076@pd7tw2no...
Larry,

Stephen's methods look like he calls the GDI+DLL directly. Is this the
same GDI+DLL that is the victim of the latest exploit? If so, then it
would be a good idea to get the post-patch version of it. More info at:
http://www.symantec.com/avcenter/sec...ent/11173.html

http://www.microsoft.com/technet/sec.../ms04-028.mspx

Bri

Larry Linson wrote:
"David Schofield" wrote

Steve Lebans had a better image display package for A97 on his
web site.

That is an excellent suggestion. I am mentally slapping myself "upside the haid" for not thinking of Stephen's http://www.lebans.com as a source, specifically http://www.lebans.com/loadjpeggif.htm.

Larry Linson
Microsoft Access MVP



Nov 13 '05 #15

P: n/a
"Stephen Lebans"
<Fo****************************************@linval id.com> wrote in
news:wO**********************@ursa-nb00s0.nbnet.nb.ca:
The GDI+ solution is only required if you need to support TIF
files. If not then use the older LoadJpegGif solution as it is
well tested and in widespread use.


None of the systems I am responsible for needed to be patched for
this exploit because they were not subject to it in the first place
(i.e., not using any of the software that is vulnerable) or they had
already been patched beyond the point where the vulnerability had
already been fixed (Win2K SP3 or higher, for instance).

And since most of my clients don't use IE, even the handful of WinXP
users were not subject to the problem.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #16

P: n/a
Bri
Stephen,

Good to know that, but since you do have the DLL available on your site
for download you might want to make sure it is the patched one. Better
safe than sorry.

Bri

Stephen Lebans wrote:
The GDI+ solution is only required if you need to support TIF files. If
not then use the older LoadJpegGif solution as it is well tested and in
widespread use.
:-)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Bri" <no*@here.com> wrote in message
news:fcX5d.123688$%S.43076@pd7tw2no...
Larry,

Stephen's methods look like he calls the GDI+DLL directly. Is this the
same GDI+DLL that is the victim of the latest exploit? If so, then it
would be a good idea to get the post-patch version of it. More info


at:
http://www.symantec.com/avcenter/sec...ent/11173.html

http://www.microsoft.com/technet/sec.../ms04-028.mspx

Bri

Larry Linson wrote:
"David Schofield" wrote

Steve Lebans had a better image display package for A97 on his
web site.
That is an excellent suggestion. I am mentally slapping myself
"upside the
haid" for not thinking of Stephen's http://www.lebans.com as a
source,
specifically http://www.lebans.com/loadjpeggif.htm.

Larry Linson
Microsoft Access MVP


Nov 13 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.