Interger converts to text on a linked table

J

Jennifer

Hi,

I have linked a MS Access database to an Oracle 9.2 table.
(used both an Oracle ODBC Driver and the Microsoft Oracle
ODBC driver). The problem is that the Oracle table has
several fields that are Integer, but access has linked
those as text and it is causing me a data type mismatch
when I try to run queries. Since I can't change field
properties on a linked table is there any way to re-link
to get a more appropriate datatype for the Integer fields.

Any suggestions would be greatly appreciated.

Thanks.
 

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

Access 2007 ODBC for Oracle linked table issue 1
Link table from Oracle database 0
Need help with Access 97 and Oracle 9i 6
Linked table field limit problem 3
Field Values When Linking to an Oracle Table 1
Access 2003 ODBC to Oracle CLOB field show in Access text type 0
Format DATETIME to Date in query on linked table 5
Multiple tables appear when Linking oracle ODBC tables 0

Top