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

You are probably experiencing an ODBC problem. I would suggest either using the exact Oracle version-specific ODBC driver or getting the latest and greatest Microsoft Data Access Control 2.0 (MDAC) drivers. MDAC 2.0 includes a very good Oracle8 ODBC driver. Configure a new DSN with a different a name using the Microsoft ODBC driver (don't have File & System DSNs with the same name, causes problems). Then use the Add Ins Attachment Manager to RE-Attach the Oracle tables.

Mike Rose

P.S. Let me know if this solves your problems at mmrose_at_home.com

tony wrote in message ...
>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 - 14:35:03 CST