Insert JPG picture in db it shows me icon

[Duangpy]

Hi,

I'm sorry if this question has been arswered, I went
though a lot of questions & answers but did not find what
I was looking for.

My problem is I converted my database from access97 to
access2000, in access97 I had no problem inserting OLE
object e.g picture of employees. However, in access2000
when I insert object to the bound object frame control on
a form it displays the file name/an icon of that object in
stead of the object iself.

When I check on the table that the object is stored (after
inserting) it displays "Package" in the OLE field with one
in insert through accesss2000. The once I inserted through
Access97 form display MSPhotoEd.3

Can someone give me a hint on this.


Thanks
Duangpy

 

[Exponent]

You need to install the MS Photo Editor application - you'll find this on the office CD. Once installed
set file associations to handle jpeg images with Photo Editor.

Note that one of the major drawbacks of this approach is that there is usually an overhead of 10 to 100
*times* the size if the original file, since internally it's stored uncompressed. If you want to store
images actually inside the database you should store them as raw-binary/blob, then there's no overhead,
and several other potential problems are avoided.

 

[Duangpy]

Thanks for your advice. I'd like to avoid increasing the
size of the database, it's now very slow.
How do I store them as raw-binary/blob? Please give me
some clues. I really appriciate you help. Thanks

Duangpy

-----Original Message-----


You need to install the MS Photo Editor application -

you'll find this on the office CD. Once installed

set file associations to handle jpeg images with Photo Editor.

Note that one of the major drawbacks of this approach is

that there is usually an overhead of 10 to 100

*times* the size if the original file, since internally

it's stored uncompressed. If you want to store

images actually inside the database you should store them

as raw-binary/blob, then there's no overhead,

 

[Exponent]

You could take a look at Larry Linson's sample database at:

http://accdevel.tripod.com

which I believe has an implementation written in vba code that you might be able to use. You would need
to ensure that all your users have the necessary Office Graphics Filters installed, or install them from
the Office CD if necessary.

Alternatively you could consider a custom control such as our own, which you can just bind and go, like
using a text control.

Or you can consider if you really need the images inside the database, and whether other approaches (using
external files) might suffice.