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 16 2503
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
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
"'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
"'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
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
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
"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
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
"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
"'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 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 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
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
"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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Veetold |
last post by:
I have a problem with displaying image files (jpg) on my report.
I got a solution from Larry Linson (Microsoft Access MVP) for which I'm
grateful, but I still don't exactly know how to link an...
|
by: sea |
last post by:
I have a form with an unbound control -- how can an user copy and
paste a .bmp image into this control? I tried to copy and paste an
image by double clicking inside this control but nothing...
|
by: Martin |
last post by:
I am using graphics as backgrounds for forms,buttons,labels etc.
The question is: is it faster to load all graphics from files on app start
or
to use it embeded (places in editor during design)....
|
by: rushikesh.joshi |
last post by:
Hi All,
I want some charting functionality in my ASP.NET application.
I want to show a multiple bar on my web page. It's based on down time
of different servers.
like
server1: down betn 4 AM...
|
by: needin4mation |
last post by:
Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
Whenever I link an image all it shows is the filename. Not the image.
Other versions of Access can link the image just fine. ...
|
by: Hamed |
last post by:
Have I posted the message to wrong newsgroup?
Or
Does the question is so much strage?
Would someone please kindly direct me to a true newsgroup or resource?
Best Regards
Hamed
|
by: Ringo |
last post by:
Please excuse the long post, but I have an issue and don;t know how to
describe it without describing the app.
I have an app that reads data fro the serial port and draws it on the
screen. I...
|
by: Ringo |
last post by:
I need some help. I have an app that talks to a sonar board via the
serial port. In my sp_DataReceived I gather all the data and put it
into arrays. Then I want to draw the data in a pictureBox. I...
|
by: koschwitz |
last post by:
Hi,
I hope you guys can help me make this simple application work. I'm
trying to create a form displaying 3 circles, which independently
change colors 3 times after a random time period has...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |