Out Of memory

[pakistranger]

hej Guys,

I am running an append query through VBA code that appends massive amount of data to one table.
After query runs for a while it gives error 3035 that it is out of memory.
How could i handle this situation. Please help? Thanks is advance.

 

[DJkarl]

hej Guys,

I am running an append query through VBA code that appends massive amount of data to one table.
After query runs for a while it gives error 3035 that it is out of memory.
How could i handle this situation. Please help? Thanks is advance.

How massive? Does the database exceed 2GB after the query fails? Basically if the database is >= 2GB there is no way to add more data and you will have to split up the data into multiple tables/databases. If it is a virtual memory issue adding more RAM to the computer can help, if that is not an option you could try replacing the massive append query with smaller append queries, find a field like a date field and restrict the amount of information being appended in one operation.

 

[TBA]

Hi

This is caused by running out of available virtual memory (VM) aka swap disk. A 32 bit app cannot use more than 2gb and for some reason Access uses a lot of VM and when it needs more and cannot get any then you run out of system resources.

Solution is to make sure your VM is at least 4 times the RAM and to restart your PC at least daily, only this clears out the VM from garbage left lying around from other apps.

You will never have had this issue on a 32 bit OS, its only now with 64 bit OS that this happens.

 

[The_Doc_Man]

I'm with TBA on this one. You'll have to go to your system tools to adjust virtual memory allocation. If you have a big enough disk, boost the size of the virtual memory file.

However, I might also suggest that you make a copy of your database before you do this append, then do a "repair and compact" of the copy, then run the append in the copy. If it works this way, your problem might be in the nature of the query. By any chance does the source of the query data involve a complex JOIN? If so, the scratch space of your database file is being consumed during creation of the intermediate result-set from the JOIN and can only be reclaimed by compaction.

 

[RuralGuy]

This is an eight year old thread.