Picture Cells

[maximusimo]

hi,

maybe a very elementary question but here goes anyway.

am having problems inserting an image field in MS Access.

when i create the table and specify the data type to be OLE Oject and add an object to this all that appears is the word "Package". Then when i output this to a webpage (via Dreamweaver MX) all i get is two symbols of nonsense (a square and ~ i think). Although any text, etc, in other fields get output with no probs. This is def an Access prob but have no idea where i am going wrong. Any help is greatly appreciated

Am i doing something wrong??

 

[psemianonymous]

OLE embedded objects are a pain in Access, especially if you need to get them back to 'file' form later. Whenever I was confronted with the problem (...once) I stored the filename in the database and kept the file in a publicly accessible area (e.g. \\etc\etc\).

In other words, spare yourself the effort and don't bother.

 

[PaulCooper]

I agree with Pseale ~ embedded images are a pain, not least because they bloat your database.

I store the path name of the image in a field called fPicture and I use a picture container ShowImage.

Each record can then point to a) a default picture or b) the relevant picture and this code, in on current, updates things as you move through the record set.

Regards Paul

'Update the picture file
    If Not IsNull(Me![fPicture]) Then
        Me![ShowImage].Picture = Me![fPicture]
    End If

 

[maximusimo]

Now the page the images will be shown on will be dynamic (asp) and so will this still work.

As a path (for images) is added to the database will this update what is shown on the resulting webpage???

 

[PHV]

Just a thought: can't the ASP generate IMG tags ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[maximusimo]

Not quite sure, havent really done much with asp to tell you the truth

 

[maximusimo]

Well eventually got it sorted,

storing the images - just have a text field in the table with the path to the picture.

To get the image on the webpage - when have created the recordset, go into the cell (in a table in Dreamweaver) where i want the picture to appear and go to insert>image and then click datasources and choose the imagepath field from the recordset - works a treat.