Board index » delphi » Update of Ole Object Field in MS Access DataBase

Update of Ole Object Field in MS Access DataBase


2003-06-30 07:44:23 AM
delphi74
I need to be able to update a OLE Object Field in MS Access , I have tried
several times and have actually updated the field but when back in MS Access
the data is corrupted. I am trying to update the object with a bitmap. Any
help would be appreciated, Thanks,
Andrew Elphick
 
 

Re:Update of Ole Object Field in MS Access DataBase

Brian Bushay TeamB <XXXX@XXXXX.COM>writes:
Quote

>I need to be able to update a OLE Object Field in MS Access , I have tried
>several times and have actually updated the field but when back in MS Access
>the data is corrupted. I am trying to update the object with a bitmap. Any
>help would be appreciated,

It appears corrupt in Access because Access stores information about the OLE
server to use with the blob data.
delphi.about.com/library/weekly/aa030601a.htm

There are a couple of components for deailing with Access OLE fields

www.gm-software.de/proddbctrl.htm
www.opus.ch/OpenSource/DBOLE/Default.htm
--
Brian Bushay (TeamB)
XXXX@XXXXX.COM
Thanks for the advice , I shall be checking out the DBOLE
component.