We were successful on linking the table from MS access to Oracle 10g, but we dont see any data in the MS access linked table. It shows as data #deleted. Can you please describe how we can see those datas.

Was there any answer to this. I'm having the same problem. Using AccessXP, I can link to Oracle Tables via Oracle 10g ODBC Driver. But when I open the table all values in fields are displayed as "#deleted". The weird thing is if I connect to the same table using MSQRY32.exe everthing displays correctly.

I have the same kind of problem.

The error message: The decimal field's precision is too small to accept the numeric you attempted to add.

The oracle-field is: NUMBER(6,3)
In Access the field is: Decimal (6,3).

Can someone tell me how to solve this problem?

To fix this, go to registry,

change all "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\NLS_LANG to "AMERICAN_AMERICA.WE8ISO8859P1".

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.