How do i trap Oracle ODBC error #deleted

[sportsguy]

i am using access against an Oracle DB through an ODBC driver, and when appending records to a local table, if access gets an Oracle record error "#deleted", the append query aborts. . . that's fine, but I can't figure out how to trap the error to get the rest of the records. . .

ugh! see attached graphic

thanks

sportsguy

 

[sportsguy]

Beuhler . . . .

Beuhler . . . .

Beuhler . . . .

Beuhler . . . .

 

[llkhoutx]

I do exactly what you're doing, appending an Access table querying millions of Oracle records via a Microsoft ODBC connection, every day ad have never encountered such a problem.

What's causing the deleted record? Is someone deleting the recordset which you're appending?

 

[sportsguy]

Hmmmm

ah, I am using the ORACLE ODBC driver. . .

no, the records are there, as I have had the DBAs check. . .

which MS ODBC driver are you using?

thanks

sportsguy