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?