Appending Pictures [OLE Objects] from one table to another (2nd Try)

[TOTCOM11]

Does anyone know if it is possible to append pictures from one table to another (OLE Objects)? I'm having a few difficulties and could use a pointer or two.

Thanks,
Chris

 

[TOTCOM11]

Just as an FYI: Here is the code I am currently trying to get to work. When I go into table view it looks like it would work correctly, the only problem is that the object doesn't ACTUALLY get copied over into my other table.

INSERT INTO tblPictureIndex ( PICTURE1 )
SELECT tblPictures.Picture
FROM tblPictures INNER JOIN tblPictureIndex ON tblPictures.PictureID = tblPictureIndex.PicID1
WHERE (((tblPictures.Picture) Is Not Null) AND ((tblPictureIndex.PicID1)=[tblPictures].[PictureID]));

 

[PHV]

And this ?
UPDATE tblPictureIndex I INNER JOIN tblPictures P ON I.PicID1=P.PictureID
SET I.PICTURE1=P.Picture
WHERE P.Picture Is Not Null;

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