If I understand you correctly, this is normal. What it means is that the
operation has exceeded the limits of what can be executed in a transaction
that can be rolled back. Executing it as a delete query may avoid the
message, though I'm not sure of that.
Dirk Goldgar, MS Access MVP
(please reply to the newsgroup)