#deleted on Oracle linked tables

R

Robert

hello,

My Access is linked to an Oracle 9 database and several
tables when I opened it, It's showing the #deleted text on
all fields. I want to know how to get around this problem.
I've installed the latest Jet 4.0 version and the problem
is still there. Any help is appreciated..
 
D

Doug Goodenough

Hi Robert,

I would check how you have defined your column attributes in Oracle and make
sure that when you view the same table in design mode in access that the
attributes are the same....Access will not recognize all column types that
oracle and SQL server have. I had a column defined as BIGINT in my sql
server table that was the culprit. Access did not know what that was so
showed it as being type TEXT. I changed the column to FLOAT and re-linked.
The table data now shows correctly in access.

Good luck,
Doug
 
Top