images - basic query?

[obaluba]

Hello, I am trying to enter images into my access table, thus far with no success.
In the datatype of the layout i have set it as 'OLE' but i get nothing when i point it to a image file

Is this fixable?

If so could i have the instructions in idiots terms!! as im new to all this!!

thanks
all help is greatly appreciated!

 

[randysmid]

Hi,
Microsoft is recommending that images not be stored within Access tables. They are recommending that you only store the location of the image. Here is a link to the topic:

http://support.microsoft.com/default.aspx?scid=kb;en-us;263021

But, if you really need to store images inside the database, here is a link to the MSDN site that shows how to use the BLOB datatype.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp

I created a test table, and included a OLE object type. Then, when I went into View mode, and right-clicked on the field, it allowed me to "Insert Object". It is here that you can select an image to insert. It doesn't actually seem to insert the actual image into the database, but rather a link to the application (e.g., Microsoft Photo Editor) and the actual image to be displayed. HTH,
Randy Smith
California Teachers Association