?
Solved

Runtime error '2004' - there is no enough memory ( Access )

Posted on 2009-05-11
3
Medium Priority
?
885 Views
Last Modified: 2012-05-06
Hi to Experts,
Suddenly, I have a strange bug in my access project.
I designed form in design mode, and after that I wanted to preview the form in runtime.
I double-clicked the form and get the following message:
" There isn't enough memory to perform this operation, Close unneeded programs and try the operation again "
But when I open another form, everything goes well.
I don't have problems with computer memory and did restarted the computer.
The problem appeared suddenly without any reason !!

Please Help me !!

I attached access file, the forms that make problems called "  frmAvodot, frmAvodotNew, frmAvodotSub "

Please help !!

Thank you



HacaatMehir.zip
0
Comment
Question by:OraDeveloper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24359748
from Access menu
Tools >database utilities> compact and repair database

from VBA window
DEBUG > compile

correct any errors that maybe raised

if problem persists do a DECOMPILE

see this link
http://www.granite.ab.ca/access/decompile.htm

after decompiling
create a new blank db and import all objects

Tools >database utilities> compact and repair database


if still the problem persists
your form is corrupted,

create a new form

from the old form, select all controls and paste to the new Form


0
 

Author Comment

by:OraDeveloper
ID: 24359922
Hello, I did what you said - decompile, and then imported all objects to a new AccessFile.
There was the same error message when I tried to import the form called " frmAvodotSub ":

" There isn't enough memory to perform this operation, Close unneeded programs and try the operation again "

Now I know what form cause the problem.

I cant copy or export that form, I get the same err message.
I cant even open it in design mode to copy the controls !!

Please help me !!

If you can extract and revive that form I will appreciate !!

You can find it in the attached file in this solution.

Thanks


0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1500 total points
ID: 24360044
ok., just look at your db.
sorry but it looks like you have to recreate your form from scratch
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question