Oracle

Accessing Oracle 10g table with MS access 2003

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2004

Posts: 11

Reputation: zaman1111 is an unknown quantity at this point

Solved Threads: 0

zaman1111

Offline

Newbie Poster

Accessing Oracle 10g table with MS access 2003

Jun 9th, 2005

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.

•

Join Date: Jul 2005

Posts: 1

Reputation: dbugme is an unknown quantity at this point

Solved Threads: 0

dbugme

Offline

Newbie Poster

Re: Accessing Oracle 10g table with MS access 2003

Jul 29th, 2005

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.

•

Join Date: Aug 2005

Posts: 5

Reputation: weilander is an unknown quantity at this point

Solved Threads: 0

weilander

Offline

Newbie Poster

Re: Accessing Oracle 10g table with MS access 2003

Aug 1st, 2005

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?