I have written an update query that updates ~224,000 records from another large table. When I am running the query, I get this message from Access: "There is not enough disk space or memory to undo the data changes this action query is about to make." It then prompts me to either continue or cancel the query. I normally will just continue and the table will be updated. What I am afraid of is if there is an issue and I cannot roll back the updates. I have researched this message to some extent and most sites say to up the number on the MaxLocksPerFile in the registry - which I have upped to 1000000 - but the message persists. Any suggestions?