I'm using MS SQL Server 7.0 and MS Access2000 with NT 4.0 sp6. I have a append query that tries to append 50,000 records from Access to SQL Server. It comes up with the error "cannot undo", which is fine, I tell it to continue, then shortly after, it comes up with "System Resource Exceeded". If I limit the append query to less records, then it works fine. I took out the identity field to avoid any other variables to the problem. I have done this before with other databases with 200,000 records.