Not enough disk space or memory error

[Jesse Aviles]

I have a delete query that supposed to delete 2,000,000+ records every time it runs. However, I
receive the following error:
"There isn't enough disk space or memory to undo the data changes this query is about to make."
I know there is space enough but I don't know how much memory will it need. I have tried it without
error with 10,000 records and it ran perfectly. Is there a limit on the amount of records a delete
query can delete? The functions that follow the flow of code after the delete query is called do
not function correctly afterwards. Will it be better to perform a loop with the delete query that
selects only, maybe, the top 25,000 records until it finds no more records to delete?

 

[Guest]

Hi Jesse,

Check out this KB article:

You may receive a "There isn't enough disk space or memory" error message
when you perform an operation on an Access table

http://support.microsoft.com/kb/286153/


Tom
__________________________________________

:

I have a delete query that supposed to delete 2,000,000+ records every time
it runs. However, I
receive the following error:
"There isn't enough disk space or memory to undo the data changes this
query is about to make."
I know there is space enough but I don't know how much memory will it need.
I have tried it without
error with 10,000 records and it ran perfectly. Is there a limit on the
amount of records a delete
query can delete? The functions that follow the flow of code after the
delete query is called do
not function correctly afterwards. Will it be better to perform a loop with
the delete query that
selects only, maybe, the top 25,000 records until it finds no more records
to delete?

 

[Arvin Meyer [MVP]]

All actions must be done in memory before being comitted to disk. Memory is
a combination of RAM and swap space (aka the pagefile) Right now, doing
nothing but reading news, I'm using 90 MB of RAM and 13 MB of virtual memory
(disk memory or swap memory) 2 million records can easily use hundreds of
megabytes of RAM.

The loop will be slower, but it should allow you to do your delete. You can
also buy more RAM or increase your pagefile size.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access