Memory Issue

[jastek]

I created a moderately complex query, which works great. However, when I try to go back into the query in design mode I get the "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." message.

To see if it was an issue with my database structure, I imported the query into a new blank database and tried to open it in design mode and it did the same thing.

Anyone have an idea what the problem here is?

 

[Pat Hartman]

The first thing to do when you get this type of error is to shut down Access and anything else that is running and reboot. Did you do that? Many programs (Access included) have what are commonly called "memory leaks". What that means is that they allocate memory and then do not properly free it. Eventually, some program has a problem. Free Cell is a real culpret if you're into the Windows games.

 

[jastek]

Yes. I tried all the basic things such as shut down and re-boot. Nothing worked.

 

[Fizzio]

Free Cell is a real culpret if you're into the Windows games

The truth finally comes out Pat

Make sure that you have almost nothing else running in Access (or anything else for that matter) and even close down some resident background programs

Depending on your OS, you may need to tinker with your virtual memory settings also.

On my older system I use a freeware called MPower which is essentially a defragger for your memory - reduced the crashes enormously. If your system is a little on the AncientOne side (who incidentally also has the same problems as yourself ) could be useful.

http://www.pcworld.com/downloads/file_description/0,fid,16880,00.asp