Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Getting #DELETED from MS Access when looking at an 8.0 table that has been truncated

Getting #DELETED from MS Access when looking at an 8.0 table that has been truncated

From: tony <ramdan_at_mailexcite.com>
Date: 19 Mar 1999 13:38:04 -0600
Message-ID: <mIxI2.19428$3I2.66783@newscene.newscene.com> 





We create a table in oracle 8.0 load data, no problems at all with access.



THEN, I truncate the table in oracle and reload some new data, now when I go 
to access it all the column values say #DELETED.  Refreshing the link or 
dropping it and recreating it does not help.  



I renamed the table and created the structure anew, then did an insert with 
select from the old table.  However, Access still is giving me problems, still 
says #DELETED.
Received on Fri Mar 19 1999 - 13:38:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US