Why can reports display Oracle data but forms cannot???

  • Thread starter oozyscab via AccessMonster.com
  • Start date
O

oozyscab via AccessMonster.com

Has anyone had an experience where data coming from a linked Oracle table can
be displayed in a report but not in a form?

The scenario is this... I have linked via ODBC (Oracle ODBC Driver version 9.
2.0.65) to an Oracle table that contains some records that have unicode
(Korean) characters in one of the fields. When viewing the data in the table
view, these records display '#Deleted' across all the fields. If I use that
linked table as the datasource for a report, I can view the Korean characters.
If I use that same linked table and bind it to a new form, the records still
display as '#Deleted'. Another cool thing is that using the same ODBC driver
and creating a passthrough query to that same Oracle table correctly displays
the Korean characters.

I'm using Access 2003, MDAC2.8, Windows XP Professional SP2, Oracle Client 9.
2.0.5.0. Also, using the Microsoft Oracle driver behaves the same way.

Cheers,
Eric
 

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

Sort order different between reports 1
How to login "Oracle ODBC Driver Connect" in the programmatically 2
Access 2003 not linked to Oracle 11g 3
SQL Help Please 2
oracle sql plus - modified table column - not showing in Access 1
Append Records to ORACLE via ODBC 0
Format DATETIME to Date in query on linked table 5
ODBC Connection 0

Top