Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 78 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by jgenin
Member Avatar for 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.

Member Avatar for 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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.