Warning message of Not enough memory

[accessfever]

i have a query to update a table of 360,0 00 records. Every tiughime I execute the query, I receive a system message that my pc doesn't have enough memeory to undo the action. What I do next is to click yes. It's kind of annoying. Is it a way to bypass or turn off the message?

 

[Banana]

I should first note that it doesn't sound right to me. It usually indicates there is something wrong. For example, your database may have exceeded 2 GB limit and needs to be compacted. Therefore, you shouldn't be even asking how to bypass that message because it shouldn't show up.

If it's not your database file size, then the next question is what happens when you wrap the query in a transaction? Does it changes anything? If not, then what is the query's SQL?

 

[accessfever]

this is a huge database with a size of 1,668,884KB. I compacted it to a size of 1,202,784 Kb after your advise. However, I still get the warning message of not enough memory and can't undo the action if I click yes to confirm the action.


The query is to update query to update a table of 361,000 records:
UPDATE [F01 Cost Compare Current Yr vs New Yr] SET [F01 Cost Compare Current Yr vs New Yr].[Note] = "<= 1% "
WHERE (((Abs([Tot Cost Diff%]))<=0.1));