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

Andrew Elphick

Delphi Developer
Fri, 16 Dec 2005 07:44:23 GMT

Update of Ole Object Field in MS Access DataBase

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

 
Brian Bushay Team

Delphi Developer
Fri, 16 Dec 2005 10:39:14 GMT

Re:Update of Ole Object Field in MS Access DataBase


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.
http://delphi.about.com/library/weekly/aa030601a.htm

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

http://www.gm-software.de/proddbctrl.htm
http://www.opus.ch/OpenSource/DBOLE/Default.htm
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Andrew Elphic

Delphi Developer
Fri, 16 Dec 2005 21:56:07 GMT

Re:Update of Ole Object Field in MS Access DataBase


Brian Bushay TeamB <BBus...@Nmpls.com> wrote:

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.
>http://delphi.about.com/library/weekly/aa030601a.htm

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

>http://www.gm-software.de/proddbctrl.htm
>http://www.opus.ch/OpenSource/DBOLE/Default.htm
>--
>Brian Bushay (TeamB)
>Bbus...@NMPLS.com

Thanks for the advice , I shall be checking out the DBOLE
component.

Other Threads

1. Manipulating MS Access OLE object fields using ADO

2. Using an access database and an OLE Object field

3. Opening an MS word doc from an Ole object stored in ms access

4. Accessing an Access OLE Object Field

5. Access Novice Needs Help - Updating Fields in database from another database

6. TDBImage and MS Access97 ole object fields

7. Displaying Embedded OLE Object using ADO from MS Access DB

8. Using MS-Access OLE fields from Delphi 3

9. Storing OLE objects in database fields

10. Images from MS Access OLE Fields