Re: ODBC, Access and Oracle problem

We recently encountered the same problem here. It was caused because Access is unable to understand Oracle's NUMBER(x,y) formatted numbers.
If any NUMBER field in our Oracle table had a value in it that was larger than 127, then that entire row's fields would show up as "#deleted".

When you change your Oracle table's NUMBER fields to have no (x,y) settings, then the Access table link is able to work properly.

For example, change your Oracle table field from NUMBER(5,0) to just NUMBER

Clearly, this is a problem, and we don't know how to get around it yet. No-one wants to reset all NUMBER fields in their Oracle tables to have no size and precision settings.
But for now, that's what we're doing.

Hopefully, in Access, there is a way around this.

Regards,

James Arvigo

• SQL Server & Oracle DBA
• Software & Intranet Developer
• The Maxim Group
• Austin, Texas *----------------------------------------------------------
• JArvigo -AT- Hotmail.com
• ( unobfuscate the email)

  ---

  njs4 wrote:

> I come to a problem. Please help me if it is
> possible and won't take too much time of you. I established
> a linked table in Access 97 with Oracle 8.0.4 with Oracle ODBC driver.
> However when I opened the linked table, the first 8 rows of data are all
>
> right, but after that all rows and all fields are saying #Deleted. I
> wonder if you know what happen and how to solve this problem as
> attached. On the other hands, if I imported from the same Oracle table
> with the same ODBC driver, it appears to be all right. Thank you!
Received on Thu Sep 10 1998 - 00:00:00 CDT