Access displays 'OLE object' on linked Oracle datetime

[jkohlmeyer]

I am using MS Access 2003 to link to an Oracle 10g table utilizing Oracles 10g ODBC driver. When I view the data everything is fine except for the datetime field (which is also an index on the Oracle side).

Access shows a value of "OLE object" in this column rather than anything resembling a date.

Anyone have any suggestions - other than a third party ODBC driver (I did find one that works, but not a viable option).

Thanks in advance,

John

[debasisdas]

That is because of the incompartibility of Access with Oracle. It shows when there is no compartible data type in access in comparision to Oracle.

[jgenin]

I am having the same problem. When I remove columns containg DATE on Oracle table, the Access Linked table works OK - I can sort and filter , etc.
I don't think remove all date fields is a workable solution. Any other ideas? Please, this is very urgent!