Incorrect field type linking Oracle table in ACCESS 2003?

H

hoopfiend

I am linking an Oracle table using ACCESS 2003. 9 of the 10 fields display
correctly when I open the table. However, the 10th field, which is date-time
in Oracle, displays as "OLE Object" in ACCESS. I know I cannot change the
field data type in ACCESS because it's only linked to the table.

How do I correct this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Access and Oracle Database 2
oracle fields exceed 255 3
Field Values When Linking to an Oracle Table 1
Linked table field limit problem 3
Doughnut Chart linked with the slicer in the pivot table 0
Linking to Oracle via ACCESS 1
How to check existence of Oracle table 0
Access 2007 ODBC for Oracle linked table issue 1

Top