#deleted showing when opening a link oracle

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

hello,

I'm linked to an oracle database and when I open it it's
showing #deleted on all fields and columns even though
I've update to the lastest Jet 4.0 and I've verified from
another oracle user that there's data in the table. Please
help. Many thanks... Microsoft is not much of a help...
 
I used to have the same problem with an Attache ODBC driver (Attache uses
the ancient version of C-Tree database engine). Then I found out that
instead of opening the DatasheetView of the linked Table, I simply need to
use a simple Pass-through Query like:

SELECT *
FROM CUSTOMER_MASTER

and the Query DatasheetView displays the Records correctly.

Not sure whether this works for you but it's worth a shot.

Note that Rows returned by Pass-Through Queries are "Read-Only" so if you
need Read/Write, this is not going to work for you.

HTH
Van T. Dinh
MVP (Access)
 
This only occurs on *some* tables, right?
Other tables are fine?

Check the structure of the broken table using Oracle tools.
How many fields?
Data types? (Any "odd" ones? Or just simple ones like varchar2, etc.)
Is there a Primary Key on the table? (This is the big question.)
Any other indexes? If so what are they named?
Access may get confused with a table with multiple indexes and pick the
first one in alphabetical order which may not be the right one. Try creating
a unique index on the PK column named aaaaa_MYPkColumn.


HTH
 
Back
Top