record is deleted in the append query,error 2950 (1 Viewer)

in my macro there are several append queries, now when i run the macro i got error "record is deleted, error 2950" on one of append query.

before migration tables to sql server i was running this macro without problem , now after migration tables to sql server i got error "record is deleted" i do not know this problem comes from where.

This may well be something to do with the issues described here in your other thread. https://www.access-programmers.co.uk/forums/showthread.php?t=296061
Error 2950 is pretty ambiguous, and come up for a variety of often unrelated reasons.

Thanks, I had not used filter(Not IN SELECT...) for append query, now is ok.