OLE Object column

[John]

I have two columns with the same data type of OLE Object. Is that possible to
update one using the other? The following gave me an error:

update table1 set colOLEObject = (select colOLEObject2 from table2 where
tableID = 1)

Thanks.

 

[[MVP] S.Clark]

What error did you get?
--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[John Spencer (MVP)]

You might try using the DLookup function.

update table1
set colOLEObject = DLookUp("colOLEObject2","table2","tableID = 1")

or This MIGHT work (UNTESTED)

Update Table1, Table2
SET colOLEObject = colOLEObject2
where Table2.tableID = 1