Ad:

Oracle Discussion Thread
Unsolved
Views: 21254

Jun 9th, 2005

Accessing Oracle 10g table with MS access 2003

Expand Post »

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.

Similar Threads

can we connect VB 6 wtih databases in Ms Office Access 2003? in Visual Basic 4 / 5 / 6
Access displays 'OLE object' on linked Oracle datetime in Oracle
how to display images in a form in access 2003 in MS Access and FileMaker Pro
Oracle Field Not Displayed Correctly In MS ACCESS in Oracle
mid problem in access 2003 in Windows NT / 2000 / XP

zaman1111

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Aug 2004

Permalink

Jul 29th, 2005

Re: Accessing Oracle 10g table with MS access 2003

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.

dbugme

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2005

Permalink

Aug 1st, 2005

Re: Accessing Oracle 10g table with MS access 2003

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

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2005

Permalink

Aug 2nd, 2005

Re: Accessing Oracle 10g table with MS access 2003

To fix this, go to registry,

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

weilander

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: error while trying to retrieve text for error ora 01019

Next Thread in Oracle Forum Timeline: selecting the records

DaniWeb Message

Cancel Changes

User Name
Password