Image files suddenly don't work

  • Thread starter Thread starter Rob Parker
  • Start date Start date
R

Rob Parker

I have an existing database, which links to .jpg image files for particular
records. It's been working fine for years. Suddenly, today, every record
with an associated image gives the following error message when the record
is opened:

"Microsoft Access doesn't support the format of the file
'C:\Pathname\Filename.jpg,' or file is too large. Try converting the file
to BMP or GIF format."

Any ideas, before I go for a serious search of the Micro$oft KB?

TIA,

Rob

PS. It also does not appear that the file association for .jpg files has
been kidnapped by a new application; they open by default in the MS Windows
Picture and Fax Viewer. Changing the default application has no effect on
the error.
 
Hi Rob,

a long shot ... but have you recently uninstalled any graphics programs?
When I first installed Office on my computer, I could not render JPG
files -- then I installed CorelDraw and after that, everything worked fine!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal,

I've uninstalled a video editing package that I'd been evaluating (which
included rendering some .jpg files into .mpg format to display in DVD
slideshow). But I can't image how that would have changed something for
Access - and, as I said, the default application association for the .jpg
file extension is still as it was.

If that is the case, then what do I need to do to get things back to the
previous state (and sorry, I don't have any system restore points set - I've
never found them to be particularly useful, and they just contribute to the
clutter; I prefer to simply install/uninstall, and if things seem messy
after, run a registry cleaner application).

And I can still insert and view .jpg files in other Office programs - just
tested with Word to be sure ;-)

Rob
 
Hi Rob,

I don't quite understand myself ... but try reinstalling another
graphics program that works with and renders JPG files...

It isn't Access that does the rendering, it is something else -- and the
common program (maybe a DLL?) must have gotten removed or changed when
you uninstalled the video editing program... one thing I do not like
about trial software.

btw, I really like Vegas for video editing :) It was hard to get into,
but once I found someone who knew it and stepped me through some basic
stuff for a couple hours, I found it very easy to use and quite powerful.



Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Try a right click on a file on your local hard drive a and see if it
offers you the opportunity to pick a default program for working with that
file type.
 
Hi Joseph,

Right-clicking on any .jpg file doesn't give me that option (directly). It
does give me a list of several applications I have that can edit/display
..jpg files in the "Open with ..." item in the right-click menu. The default
association works, and any of the others also work. Changing the default
application/association doesn't have any effect on the error message from my
Access database (as I mentioned in my original post).

Any other suggestions? I consider myself to be a pretty knowledgeble PC
user, and Access developer, and I'm completely at a loss here. Any thoughts
gratefully accepted.

Rob
 
Rob are you linking via the standard Image control's Picture property or the
OLE Frame control?

Have you placed a Breakpoint on the line of code that sets the Picture
proper to verify that the Pathname and FileName vars contain valid strings?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Rob said:
Hi Joseph,

Right-clicking on any .jpg file doesn't give me that option
(directly). It does give me a list of several applications I have
that can edit/display .jpg files in the "Open with ..." item in the
right-click menu. The default association works, and any of the
others also work. Changing the default application/association
doesn't have any effect on the error message from my Access database
(as I mentioned in my original post).
Any other suggestions? I consider myself to be a pretty knowledgeble
PC user, and Access developer, and I'm completely at a loss here. Any
thoughts gratefully accepted.

Rob
Click to expand...

Sorry, that was my only idea and at that I did not know if there was
much chance of it working.

If you don't get an answer to your problem, you may want to do some
searching, I believe there was a like question not too long ago and if it is
still on the server you are using, you might be able to find it.
 
Thanks for the suggestion, Joseph.

I'll have a search for previous posts on this topic.

Rob
 
Hi Stephen,

I'm using the standard image control, and setting the Picture via
Me.imgPicture.Picture = pathname & Me.PictureFilename & ".jpg"

Pathname is correct. PictureFilename is correct. As I said, this is an
existing database which has been working fine for several years. It's on a
local machine; no network connections involved. Nothing that I know of has
changed to cause this.

Rob
 
And a follow-up, with some more (unsuccessful) information.

I've searched the Access newsgroups, and the MS Knowledge Base, and found
several similar problems. The answer seems to lie with the image converter
file used by Office (jpegim32.flt, located in C:\Program Files\Common
Files\Microsoft Shared\Grphflt).

I checked this file, and found that the version I had was from an Office
2007 Beta, which I recently removed from my system. Thinking that perhaps
this was related to my problem (I'm unsure if I have used this database
since removing the O2007 Beta), I decided try resetting my Office
installation (Office XP).

I've tried removing the graphic converter for Office and then re-installing
it via the Change Office setup; I've tried Detect and Repair errors in
Office, and I've even directly extracted the jpegim32.flt file from the
Office.cab file, and still no joy. After each of these attempts, I could
insert/view .jpg files in a Word document, but Access is still spitting the
dummy on them.

Any suggestions to get it to work as it previously did would be gratefully
received.

Rob
 
And a final follow-up:

CURED!!!!!

I did some registry browsing, and found some of the keys related to shared
tools were missing or incorrect (perhaps as a result of my Detect/Repair
Office activities. So I re-imported the entire set of keys at
http://www.mvps.org/access/downloads/Set_ShowProgressDialog_To_No.reg and
now I'm back in business. And thinking about that, it might be that it
originally broke when I was trying to get MS Outlook to run a couple of
weeks ago, and did a repair of my Office installation back then.

Thanks for all the suggestions anyway,

Rob
 
Morning Rob,
I posted a resolution to your issue last night at 10:17pm. I'm not sure why
it still has not made it to the MS Server.

Anyhow, what's important is that you solved your issue. Thanks for posting
back to this thread as the next person with this issue will appreciate the
ability to GooglgeGroups and find your solution.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Rob said:
And a final follow-up:

CURED!!!!!

I did some registry browsing, and found some of the keys related to
shared tools were missing or incorrect (perhaps as a result of my
Detect/Repair Office activities. So I re-imported the entire set of
keys at
http://www.mvps.org/access/downloads/Set_ShowProgressDialog_To_No.reg
and now I'm back in business. And thinking about that, it might be
that it originally broke when I was trying to get MS Outlook to run a
couple of weeks ago, and did a repair of my Office installation back
then.
Thanks for all the suggestions anyway,

Rob
Click to expand...

Good troubleshooting. Glad to hear you are back in business.
 
Hi Rob,

Thanks for sharing

did you make all those changes manually or is there a process to
automatically incorporate those entries?


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal,

I started making some manual changes, to the keys I noticed were wrong or
missing. But the easy way is this:

The link I posted gives a page of text. Cut/paste to a text file (I used
Notepad), and save as a .reg file. Then all you need do is double-click the
file, or right-click and choose "Merge", to merge the entries into your
registry. For a 19kb file of entries, that's certainly faster than
entering them all manually ;-)

Rob
 
Thanks, Rob ;)

what was the source of the information for the text file?


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal,

The text (reg) file on The Access web site can be found via the link on the
Suppress the "Loading Image" dialog page,
http://www.mvps.org/access/api/api0038.htm.
It's in a paragraph in section B which reads "This registry file, from Tom
Wickerath, ...". The Access Web site does not (as far as I have found)
mention that you can save this with a .reg extension and apply it - that
seems to be assumed knowledge. The registry file is also not available
directly from the Downloads page of The Access Web.

Finally, I should perhaps mention that the registry file contains
considerably more entries than are required to just suppress the "loading
image" message. I'd previously had registry keys for that (it was really
that they were incorrect that alerted me to that fact that my registry
entries were screwed up), but I was just using the changes described in
section A of the Suppress the "Loading Image" dialog page; they were not
nearly as extensive.

Hope this is useful,

Rob
 
Hi Rob,

thank you, that was most helpful!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top