Out of Memory

[Rodney In Trouble]

My Access program always display "out of memory" even
though I use 128Mb RAM. I also tried it on other PC's w/
the same capacity but also failed.

Please help!

 

[Microsoft]

Hi,

If you want someone to help, you will need to give some more information
please. One or more of the following would be helpful:

Do you get the Out of Memory straight away, or is it after a period of time?
Does the application start up before you get the message, or does it crash
before then?
Can you give greater detail on the type of program, and do you have any idea
about what is happening at the point of the crash?
Is there any relevent source code you could show?

Regrads,

ChrisM

 

[Tony Toews]

My Access program always display "out of memory" even
though I use 128Mb RAM. I also tried it on other PC's w/
the same capacity but also failed.

The "out of memory" message could be a resources problem rather than
strictly a RAM problem. For example repeatedly opening and closing a
form thousands of times, even on a 256 Mb Win NT 4.0 system running
A97 can run out of resources. As I discovered in one particular case.
I now hide that form instead of closing it. I also had to ensure that
I initialized all variables in VBA code rather than assuming they were
null or zero. See ACC2000: Opening Form 100s of Times Affects System
Resources http://support.microsoft.com/?kbid=Q248910

There was one posting indicating a new video driver fixed their
problem. I was having problems with one video card when I had the
latest drivers installed. I uninstalled them and installed the latest
Windows Certified drivers they had which were about six months or a
year older. And things run much smoother.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm