Updating OLE Object

[Katy]

In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?

[Darryl Kerkeslager]

This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use OLE
photos in your tables - just use the path to the image as a text field, then
when you want to view the photo, update an image control's picture property
(initially set to 'none'):

Me.imgPhoto.Picture = "\\server\img1.jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermail.co.il> wrote in message
news:87**************************@posting.google.c om...

In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?

[Katy]

Thanks, but this solution is not suitable for me. I must use OLE on
the table and all images should be stored on this table as embedded
and there is no way to store them as linked (company policy)(if there
was such a possibility than your solution was suitable).
Thanks again
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message news:<Rb********************@comcast.com>...

This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use OLE
photos in your tables - just use the path to the image as a text field, then
when you want to view the photo, update an image control's picture property
(initially set to 'none'):

Me.imgPhoto.Picture = "\\server\img1.jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermail.co.il> wrote in message
news:87**************************@posting.google.c om...

In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?

[Darryl Kerkeslager]

Do you have an error-trap around the statement? Usually the Access error
messages are at least somewhat more helpful then a run-time error. What is
the line of code and the error message generated (with error-trapping)?

Just an off-the-cuff guess, though, but this sounds like the kind of error
you get when you accidentally use an Access reserved-word as a variable.

Darryl Kerkeslager


"Katy" <ka***@intermail.co.il> wrote in message
news:87**************************@posting.google.c om...

Thanks, but this solution is not suitable for me. I must use OLE on
the table and all images should be stored on this table as embedded
and there is no way to store them as linked (company policy)(if there
was such a possibility than your solution was suitable).
Thanks again
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message

news:<Rb********************@comcast.com>...

This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use OLE photos in your tables - just use the path to the image as a text field, then when you want to view the photo, update an image control's picture property (initially set to 'none'):

Me.imgPhoto.Picture = "\\server\img1.jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermail.co.il> wrote in message
news:87**************************@posting.google.c om...

In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?