Record Is Deleted.

[Bev]

I am running an append query utilizing data from a linked table and linked
ODBC tables from an AS400.

The resulting records are appending to another database.

The query starts to run. About 1/ the way through I get the above message.

I have completed a compact and repair on all Access databases and still
receive this message.

Any help would be appreciated.

 

[Bill Mosca, MS Access MVP]

Bev

You might try a refresh or a requery after the delete. Sometimes Access
can't stay up on a linked non-Jet table's indexing.

 

[Bev]

I guess the problem is I don't know what is deleted? I get this message when
I run an append query.