Image files suddenly don't work

[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.

 

[strive4peace]

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
*

 

[Rob Parker]

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

 

[strive4peace]

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
*

 

[Rob Parker]

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 Parker]

Thanks for the suggestion, Joseph.

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

Rob

 

[Rob Parker]

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

 

[Rob Parker]

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

 

[Rob Parker]

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

 

[strive4peace]

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
*

 

[Rob Parker]

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

 

[strive4peace]

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
*

 

[Rob Parker]

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

 

[strive4peace]

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
*