Form does not open in design view

[Tasmania]

I have form with subform and buttons. This form is the main data entry form
which allows user to view, and edit data, and open few other forms thru this
also. While I am in design view of this form, I get a memory error -
something like "You do not have enough memory to perform this operation,
close all other application". I closed all other open windows application.
Then hit OK. but the message stays. Then Access 2003 terminates, and gives
the Microsoft "Send Error Report" message. The database did not create a
backup copy, which it should. Now I open the database again and try to open
the form in design view, but the form would not open. I have 53 gigs of
avalable memory space in my computer. This is the fourth time I have this
error. Does anyone have any idea what is causing it? Thanks in advance for
your input.

 

[Jeff Boyce]

A point of clarification ...

It seems quite unlikely that your PC has "53 gigs of available [RAM]" ... I
believe the error message is describing a working memory ([RAM]) condition,
not a "hard-drive" condition.

If something has subtly corrupted the form, you might have to delete it and
restore/copy it from a backup.

Have you: 1) made a backup of the current .mdb, 2) tried Compact & Repair,
3) tried /decompile & recompiling, 4) tried JetComp?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tasmania]

....my mistake. The error is working memory condition.

I did try compact & repair. I created another db and try to import all the
objects from the current database, but the form stays the same. All other
forms work fine but the corrupt one. I do have copy of the DB but it's not
the most updated one.

How do I decompile/recompile?
I don't know how to jetcomp?

--
thadi

A point of clarification ...

It seems quite unlikely that your PC has "53 gigs of available [RAM]" ... I
believe the error message is describing a working memory ([RAM]) condition,
not a "hard-drive" condition.

If something has subtly corrupted the form, you might have to delete it and
restore/copy it from a backup.

Have you: 1) made a backup of the current .mdb, 2) tried Compact & Repair,
3) tried /decompile & recompiling, 4) tried JetComp?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have form with subform and buttons. This form is the main data entry
form
which allows user to view, and edit data, and open few other forms thru
this
also. While I am in design view of this form, I get a memory error -
something like "You do not have enough memory to perform this operation,
close all other application". I closed all other open windows
application.
Then hit OK. but the message stays. Then Access 2003 terminates, and
gives
the Microsoft "Send Error Report" message. The database did not create a
backup copy, which it should. Now I open the database again and try to
open
the form in design view, but the form would not open. I have 53 gigs of
avalable memory space in my computer. This is the fourth time I have this
error. Does anyone have any idea what is causing it? Thanks in advance
for
your input.

 

[Jeff Boyce]

Do an on-line search for MS Access /decompile for instructions.

You can probably find a copy of JetComp the same way, searching on-line.

Regards

Jeff Boyce
Microsoft Office/Access MVP

...my mistake. The error is working memory condition.

I did try compact & repair. I created another db and try to import all
the
objects from the current database, but the form stays the same. All
other
forms work fine but the corrupt one. I do have copy of the DB but it's
not
the most updated one.

How do I decompile/recompile?
I don't know how to jetcomp?

--
thadi

A point of clarification ...

It seems quite unlikely that your PC has "53 gigs of available [RAM]" ...
I
believe the error message is describing a working memory ([RAM])
condition,
not a "hard-drive" condition.

If something has subtly corrupted the form, you might have to delete it
and
restore/copy it from a backup.

Have you: 1) made a backup of the current .mdb, 2) tried Compact &
Repair,
3) tried /decompile & recompiling, 4) tried JetComp?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have form with subform and buttons. This form is the main data entry
form
which allows user to view, and edit data, and open few other forms thru
this
also. While I am in design view of this form, I get a memory error -
something like "You do not have enough memory to perform this
operation,
close all other application". I closed all other open windows
application.
Then hit OK. but the message stays. Then Access 2003 terminates, and
gives
the Microsoft "Send Error Report" message. The database did not create
a
backup copy, which it should. Now I open the database again and try to
open
the form in design view, but the form would not open. I have 53 gigs
of
avalable memory space in my computer. This is the fourth time I have
this
error. Does anyone have any idea what is causing it? Thanks in
advance
for
your input.

 

[Marty]

Do an on-line search for MSAccess/decompile for instructions.

You can probably find a copy of JetComp the same way, searching on-line.

Regards

Jeff Boyce
Microsoft Office/AccessMVP

...my mistake.  The error is workingmemorycondition.

I did try compact & repair.  I created another db and try to import all
the
objects from the current database, but theformstays the same.   All
other
forms work fine but the corrupt one.  I do have copy of the DB but it's
not
the most updated one.

How do I decompile/recompile?
I don't know how to jetcomp?

A point of clarification ...
It seems quite unlikely that your PC has "53 gigs of available [RAM]" ....
I
believe the error message is describing a workingmemory([RAM])
condition,
nota "hard-drive" condition.
If something has subtly corrupted theform, you might have to delete it
and
restore/copy it from a backup.
Have you:  1) made a backup of the current .mdb,  2) tried Compact &
Repair,
3) tried /decompile & recompiling,  4) tried JetComp?
Good luck!
Regards
Jeff Boyce
Microsoft Office/AccessMVP
I haveformwith subform and buttons.  Thisformis the main data entry
form
which allows user to view, and edit data, and open few other forms thru
this
also.  While I am in design view of thisform, I get amemoryerror -
something like "You donothaveenoughmemorytoperformthis
operation,
close all other application".  I  closed all other open windows
application.
Then hit OK.  but the message stays.   ThenAccess2003 terminates,and
gives
the Microsoft "Send Error Report" message.  The database didnotcreate
a
backup copy, which it should.  Now I open the database again and try to
open
theformin design view, but theformwouldnotopen.  I have 53 gigs
of
avalablememoryspace in my computer.  This is the fourth time I have
this
error.  Does anyone have any idea what is causing it?  Thanks in
advance
for
your input.

- Show quoted text -

I had a form that could not be opened even in design mode. I imported
a the same form from a functioning backup of the mdb. This solved the
problem. Hope this helps.

 

[Linq Adams via AccessMonster.com]

As Marty suggested, if you have a working copy of the db, then copy the
current db abd save it somewhere, delete the offending form from the orignal,
and import the form from the working backup copy.

ACC2003 apparently has a history of causing this type of problem in a vast
number of situations. I seem to remember one instance of an OOM problem with
Access 2003 that was created when Internet Explorer 6 was installed on the
system! Here's a link to an Office site that has a huge number of hits for
OOM problems with 2003.

Good luck!

Linq

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com