Insert query with OLE Object

[Guest]

Hi all,

I am trying to query a table and populate another table wit hthe result of
the query. Everything works fine except for pictures in the table stored as
OLE objects. The Pictures don't move into the new table. Is there a way this
can be done?

thanks

 

[kingston via AccessMonster.com]

It actually might be working but since Access deals with pictures so poorly,
it is causing a tremendous increase in file size. Paste one picture into an
OLE field and check on the increase in file size to see what I mean.
Instead of creating an OLE field and embedding the picture, use a query to
point to the picture field in your other table. Or move all of the pictures
out of Access and create text fields for links to the picture files. This
will make your database much faster. You can view the pictures in forms by
including an Image control and changing the .Picture property to the field
value (e.g. \path\file.jpg). HTH