Access 2007 ODBC for Oracle linked table issue

[Eliza123]

Hi,

I am using Access 2007 to link to an Oracle 10g database. So far I can link
to all of the tables successfully, except for one. When trying to link to
this table I receive the error “ODBC—call failed [Microsoft][ODBC driver for
Oracle] error in column 11: Numeric value out of range (#0)â€. I have tried
using the driver that comes with the Oracle client software, but I receive
the error message: “ODBC—call failed [Oracle][ODBC] Numeric value out of
range.†I have been looking for resolutions, but have only been able to find
resolutions for Access 2003 – and so far they haven’t work. I contacted my
DBA support team, but they assure me it’s an Access issue – unfortunately
they don’t support access. Any help is greatly appreciated. Thanks.

Eliza

 

[AccessVandal via AccessMonster.com]

It might not help but here goes.

A link from Oracle Technet. Is there any patch for oracle?
--------------------------------------------------------------------------
"You folks are hitting bug 4608183
If you have access to metalink you can check that

This issue is fixed in Oracle Client Patchset 10.2.0.2"
---------------------------------------------------------------------------
"If you have Metalink access, I'd recommend checking all 3 of these notes:

Note.257828.1 Ext/Pub Full Table Scan While Quering DATE Columns Using Oracle
ODBC Driver:
Note.403198.1 Ext/Pub Full Index Scan in Execution Plan With Access and
Double or Float as Primary Key:
Note.373129.1 Ext/Pub Slow Performance Exhibited by Oracle ODBC Against 10.2
Oracle Database: "

The above are from Oracle discussion. Looks like you have a datatype problem
and index problem.

Hi,

I am using Access 2007 to link to an Oracle 10g database. So far I can link
to all of the tables successfully, except for one. When trying to link to
this table I receive the error “ODBC—call failed [Microsoft][ODBC driver for
Oracle] error in column 11: Numeric value out of range (#0)â€. I have tried
using the driver that comes with the Oracle client software, but I receive
the error message: “ODBC—call failed [Oracle][ODBC] Numeric value out of
range.†I have been looking for resolutions, but have only been able to find
resolutions for Access 2003 – and so far they haven’t work. I contacted my
DBA support team, but they assure me it’s an Access issue – unfortunately
they don’t support access. Any help is greatly appreciated. Thanks.

Eliza