Hello Everyone!
Advanced thanks for helping me here.

Whenever, I am opening Access 2002 application,
the error pops saying,

"There isn't enough memory to perform this operation. Please close unneeded programs and try again."

With this, I have to kill the Access App through Task Manager.

I have been working on this Application from past 6 months, and never did I encounter this problem before.

I dont know what's the cause for this error. Tried following ways, but none seem to be helpful

1. Uninstalled Access 2002 and installed again

2. Thought database is corrupted, transferred files to new one and compiled, no errors on compilation. New database still shows same error.

3. Application opens a main form with a autoexec, so I opened the app holding the shift key. DB is shown, but if I use any menu item, again the same error pops up.

I greatly greatly appreciate if someone can help me out in knowing the cause for this unexpected memory leakage. It is kind of urgent to make some changes in app and its not allowing me.

Thanks a lot,
Lavanya

"There isn't enough memory to perform this operation. Please close unneeded programs and try again."


If it is possible post your autoexec that you are using here, so I can look at the code you are using, or just email it to me. Also it would help to know what operating system you are using, plus how much memory the puter has. If it's XP, you may be causing the out of memory error, with the code in the autoexec. Also there may be a way around using the autoexec all together.

Robert J. Taylor

Does your machine have more than one gig of memory.

I remember Microsoft stating that they had problems with the jet engine 3.0 and below. You may want look into this and or upgrade your jet engine above 3.5