Jpeg compatibility in Access

[adamburton]

Hi,

I spent the whole weekend trying to add jpeg pitcures into my database but couldnt get it to work. I came to the conclusion that Access is not compatible with jpeg. However, I wondered if somebody out there might be able to resolve the problem.

I created a bound ole object field onto a form, and attempted to drag in a jpeg file. However, rather than display the picture, it only displays the filename. When doing exactly the same with a .PSD (photoshop) file the pictures displays perfectly. Unfortunately the file size of .psd's are massive compared to jpegs.

If anybody has experience of this, I would love to hear.

thanks,
Adam.

 

[Nero]

JPegs are compatible with Access.
Are you using Office or stand alone Access?
Have you added the Jpg Interchage Filter ?

 

[adamburton]

jpeg interchange filter

I am using the full version of Access. Not sure about the jpeg interchange filter though, so that would probably mean i havent added it.

can you advise what it does and where i would look for it.

thanks very much,
adam.

 

[Nero]

With Office, run the setup again and select Add & Remove Features.
Then go to Converters & Filters > Graphic Filters>Jpeg Interchange Format.
Select Run from my computer.

Not too sure if this is the same for standalone Access.
If I remember right Office installs it automatically but with SA Access you need to update it manually.

 

[adamburton]

Thanks

Thanks Nero,

I will have a look later on when I get home.

kind regards,
Adam.

 

[adamburton]

Still vexed!

Hi,

I looked on the CD but it seems the JPEG Interchange Filter was already installed. I created a db on my works version of Access and tried pulling a JPEG file into a bound ole object on a form - it worked fine! But at home, it wont display the picture - all it will display is the filename (stretched, or zoomed according to which picture resizing selection I have chosen).

The only difference between my works Access and home Access that I am aware of is that work is '97 while home is 2000. Seeing as my home copy is a later version I wouldnt have thought the problem would be that.

If anybody can help I will be most grateful.

Thanks,
Adam.

 

[Rich]

Access doesn't like graphics at all, whatever format you use if it's a bound object Access will bloat, your better off linking to the image

 

[adamburton]

Thanks Rich,

I lifted the process to follow for linking objects from a previous thread. It does look really good for single form pictures. but i wanted pictures on a continuous form - and it wont work this way.

I would accept that its a pain and think of something else, except that it works on my work pc so should work at home. As for bloating, Im currently using .psd files which are about 100kb to start with before going into Access. The equivalent jpeg will be about 5-10kb so will be sooooo much better. I just dont understand :-(

Adam.

 

[Nero]

The problem is the ole object is being displayed as a package rather than the image. I have had this problem before but unfortunately cannot remember what I did to fix it. I have a feeling it may be something to do with imaging software on your pc.
Do you have the same software at home as at work?

 

[adamburton]

Hi Nero,

You are right - it is showing it as 'package' within the table. Sorry for sounding dumb, but Im unsure as to what software you are referring to? I have Photoshop 7.0 at home but not at work - dont know if thats what you mean. I dont have any imaging package at work.

Adam.

 

[Rich]

This article should help explain why jpegs might not be the best choice
Article ID: Q123151

 

[Nero]

I'm not sure if I'm right but if you have say Photo Editor at work the ole object will use Photo Editor as the sort of underlying software for the image.
If you then take you database home and you don't have Photo Editor then it will package the object rather than display it.
I havn't explained it too well have I

 

[adamburton]

I understand what your saying Nero and it does make sense. However, its not the same database that Ive used between home and work. I created a brand new 'test' db at work just to see what would happen. So, this seems to rule that out. I wonder if somehow Photoshop is laying claim to the jpeg file, which somehow is restricting Access from recognising it as such. I dunno - just a thought.

Thanks for the link to the article Rich, I will have a look. However, its just really bugging me now why it works at work but not at home so Im determined to get to the bottom of it.

Adam.

 

[adamburton]

By the way Rich, can you tell me how I get to that article. Ive looked all round the site, but cannot find it.

thanks,
Adam.

 

[The_Doc_Man]

I have used JPG files on AC97 all the way through ACXP with no problem. The catch is that I had to write some VBA code to place the name of the external file in the .PICTURE property of the image control. I did this in the OnCurrent event, I think. (Been a while since I did it.)

The complete file specification was in my database as a string that looks like "device:/path/name.type" and all I did was copy that field to the control's property. Just to make life easy (and to be lazy) I put the literal file name on the form so all I would be doing is copying the contents of a simple text box to the appropriate property in the image.