creating a ole-field

[sb]

Hi,

I'm would like to create a field that is a OLE-Object, but I don't have that
to choose from in the datatype-field. I need that sort of field to be able
to insert a picture to a certain post.
What shall I do?

/Staffan

 

[Roger Carlson]

The usual solution is to NOT store the picture in a field. This can quickly
bloat your database. The best solution is to store the picture on the hard
drive and simply store the path and file name to the file in the database.
Then you can programmatically load the picture into a form (or report) into
an unbound Image Control.

On my website (see sig below) is a small sample database called
"Picture.mdb" which illustrates how this is done.

 

[sb]

I have downloaded it and tried to use it, but when I try to do it in my
database, I can't get the picture just to a specific post, it views in all
posts.
I insert picture when I have the databse in form and design view. But when I
go back to the normal view where I enter text, I can't find where to insert
a picture, please help me someone.

/Staffan