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.
zaman1111 0 Newbie Poster
dbugme 0 Newbie Poster
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.
weilander 0 Newbie Poster
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?
weilander 0 Newbie Poster
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.