OLE Object

[Hillary]

I have linked Access to our MRP system via Oracle ODBC Driver which runs on an Oracle platform. One of the fields is coming over as OLE Object in the table design and just says "OLE object" in each of the records in datasheet view. The field name is Bits.

Does anyone know of a way to make the data inside this field visible?

Thanks,

Hillary

 

[vwhite]

Hillary,

I believe you can only view it in form or report view using a bound object frame.

Regards



....vwhite

"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama

 

[Hillary]

I created a form for this. This is my first time trying to link a field this way so I'm not sure what I'm doing. I'm trying to use the help files but I don't understand all the terminology.

In the (OLE Object) field properties on the form I set OLETypeAllowed to Linked and UpdateOptions to Automatic. When I do that I get the message, "A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control. Close the OLE Server and restart it outside Microsoft Access. Then try the original operation again in MS Access."

I don't understand what I'm supposed to close or restart. I have an ODBC set up, is it using the ODBC to communicate or something else???

Also, on the field properties, Class, Source Doc and Source Item are all blank. Is that okay?

Thanks for your help.

Hillary

 

[vwhite]

Hillary,

Do you know what is actually in this field? I know OLE Objects can be things like Excel Documents, Word Documents, Bitmaps etc but if it is something obscure maybe you won't be able to view it.

Try the following:

Set the record source of the form to be the table
Set the following properties of the Bound Object Frame
ControlSource = Name of field
UpdateOptions = Automatic
OLETypeAllowed = EIther

Leave Class, Source Doc and Source Item all blank..

If it is a linked OLE Object i.e it is not actually stored in the database, but somewhere else and the field just provides a link to it, then you may not have access to it..





....vwhite

"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama

 

[Hillary]

There is only text in this field. In the database I'm linked to, all memo type fields come over like this.

I set Control Source, Udate Options and OLE Type Allow to the values you suggested above and I'm still getting the same error.

Since there is only text in this field there must be some way to extraxt it, right??? Any more suggestions???

Thanks,

Hillary

 

[vwhite]

Apparently the Oracle Long Raw field (a variable length field) gets translated into an OLE object field in Access...but that's about as much as I know....

Have you tried importing the data instead of linking it?

sorry I cannot be of more help. You may get more joy in the Oracle forum...

....vwhite

"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama