Any idea how to code in Access 2002 to release memory allocation?

  • Thread starter Thread starter das
  • Start date Start date
D

das

Hi,

In regard to the above, I always have this problem to hit
out of memory half way when my Access program is running
in progress.

Can anyone help me how to release memory allocation or
setting somewhere to manage memory allocation?

Thanks,
Das
 
das said:
Hi,

In regard to the above, I always have this problem to hit
out of memory half way when my Access program is running
in progress.

Can anyone help me how to release memory allocation or
setting somewhere to manage memory allocation?
Click to expand...

There is no setting and memory management is done by Windows, not Access.
Typically, when you run out of memory in Access 2002, it is because of
something like a Cartesian Product in a query which can cause the query to
run until there are no more resources available.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Memory management is a Windows function, not Access.

However, it you consistently have memory problems when using Access, it is
possible that your code leaves used objects in the memory. Even though
Access is supposed to destroy objects when they out of scope, there are
cases that objects are left undestroyed in the memory and reduce the memory
available for later processing.

You need to check through your code and whenever you create an object, you
should destroy it (closing and setting the object variable to Nothing) when
you finish using it.
 
Back
Top