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
Jump to PostThat is because of the incompartibility of Access with Oracle. It shows when there is no compartible data type in access in comparision to Oracle.
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.
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!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.