I have a module that produces a number of reports. Usually this runs without problem, but as the data collected has grown and the number of reports has increased, the module occasionally runs out of memory. I realise I can split the module but is there a programatic way that I can release the resources between the production of the reports?

Thanks
Paul

Paul

__________________
Paul

Here is what I found:
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 (http://support.microsoft.com/kb/245025/EN-US/) OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

The problem is that Access does not release memory until a script (vba) has finished running. Since 2000 and later are Unicode, the memory required is much greater than with 97.

You may have to split your code if this isn't the issue.

I was looking for a ReleaseBuffer() or ReleaseMemory() function, as in .NET, but didn't find anything.


mmcdonal

Thank you mmcdonal. I find I can prevent the error happening if I am in the debug window. I can split the module too. I'm running Access 2002 and will be upgrading to 2003 soonish. Maybe that will make the problem worse?

I was sure I had seen something previously in a manual or a procedure I was reviewing, which gives the operating system a small breather, but I cant seem to find it again. Should have taken note the first time.

Appreciate your help.
Cheers
Paul

Paul