Avatar of etech0
etech0Flag for United States of America

asked on 

Access form won't open, "Not enough memory"

Hi!
I was in the process of editing a complex form in Access 2003. At one point, when I closed the form (in design view) and tried to open it in form view, I got an error that access cannot complete the operation because there is not enough memory.
I know that the problem is not my computer, because I am able to open the database on another computer (with Access 2010), and when I try to open that form, or export it, or anything, I get the same memory error.
This form would take hours, if not days, to recreate.
Is there anything I can do?
Thanks!
Microsoft Access

Avatar of undefined
Last Comment
etech0
ASKER CERTIFIED SOLUTION
Avatar of Michael Carrillo
Michael Carrillo
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of etech0
etech0
Flag of United States of America image

ASKER

Thanks for your quick response.

How can I compact and repair?
The second computer is fully updated.
I cannot open design mode, I can get to the code.
In Access 2010 Click databasetools|compact and Repair database.
Something else you can do is move the contents into a new database.  this often resolves problems like this.

1. Make a backup copy of your original database.
2. create a new blank database.
3. import all objects from old database into new blank database.
4. test if you can now edit and view your forms.

Finally, if you still cannot get access to the form, then I would save all my work and do a system reboot. To ensure that my system is not experiencing a memory glitch.
SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of etech0
etech0
Flag of United States of America image

ASKER

I can't even open the form to copy it.
However, as most of today's work was VBA, I just opened a backup, copied in the new code, and it seems to be working. I did backup again after redoing my changes to the form's design - and hope there will be no more issues.
Avatar of etech0
etech0
Flag of United States of America image

ASKER

Thanks for your help!
Avatar of Nick67
Nick67
Flag of Canada image

<<and hope there will be no more issues.>>

There almost certainly will be.
Once an object gets 'brittle' the more you mess with it the more likely it is to go south.
I'd rebuild the object per my instructions sooner rather than later.  Been there, done that.

Note too that it is a very dangerous thing to edit objects in both Access 2010 and Access 2003.  Go ahead and create an autoform in Access 2010.  Now open the file in Access 2003 and begin to mess extensively with the design.  Within half an hour, you will have a corrupt object.  Pick one version or the other for development!  And keep good backups
Avatar of etech0
etech0
Flag of United States of America image

ASKER

Can't do that until the office gets in a new computer for one of the users. Should be here this week. I restored a backup version of the table - should I expect problems?
Avatar of Nick67
Nick67
Flag of Canada image

<Can't do that> What? <keep good backups>

All it needs to be is a copy of the file, in another folder, on a thumb drive, whatever
<should I expect problems>

In my experience, the problem object continues to have problems--especially if it's design is being altered--until it is rebuilt from scratch.  Copying the object and pasting won't do!
Avatar of etech0
etech0
Flag of United States of America image

ASKER

What about copying the controls on the object to a new blank form, along with the code?
Avatar of Nick67
Nick67
Flag of Canada image

<4. Copy all the controls from the old object>

That's the idea.
Create a new object in design view
Open the old object in design view
Copy EVERYTHING about the old object (controls, code, recordsource, background picture or colors, tiling of background picture ect) onto the new object so that you have a perfect replica)
Close and rename the old one
Give the new one the old one's name
Test
Avatar of etech0
etech0
Flag of United States of America image

ASKER

Got it!
Thanks for your help!
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo