Photos Appear on Some PCs but not others

[doyle60]

I have a split database with a folder of photos kept on a server. In a
form, an image control's Picture property is updated when the user
changes from one record in the sub to another. It all works very fine
on my computer and on some others. But some computers get errors.

It works on this machine:

1) Windowns 98 SE (With Access 97 (SR-2)

But does not work on these machines:

2) Windows 2000 SP4 (With Access SR-2)
3) Windows 2000 SP4 (With Access SR-1)

My own system is:

4) Windows 2000 SP4 (With Access SR-2)

As a test, we made some files bmps. Computer 2 above works if the
files are .bmps and not .jpgs. It will allow the first jpg to load,
but fails on the second jpg file, getting this error:

Run-time error '2114': Microsoft Access doesn't
support the format of the file '[It names my path to
the photograph here].jpg,' so it can't

So it works on the older computers but not the younger ones.

Computer 3 won't even open the first jpg file like computer 2. It gets
the error message above immediately.

Bitmaps work on 3 as well without error.

What do I need to do to these younger computers to get them to work
with jpg files? The files are only 50 to 75 KBs.

Thanks,

Matt

 

[Larry Linson]

I don't know what's happening on the machine where it displays one .jpg and
doesn't display any more. I suspect that when you loaded Office 97 on the
Windows 2000 machines, you did not check the Graphics Filters to be loaded.
Or, perhaps you loaded standalone Access 97 on those machines -- it does not
come with the graphics filters, which are available only on the Office
product or standalone Microsoft Word. Without the graphics filters, you
can't display .jpg files.

Larry Linson
Microsoft Access MVP