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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Thanks for your help!
<<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
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
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?
<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!
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!
ASKER
What about copying the controls on the object to a new blank form, along with the code?
<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
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
ASKER
Got it!
Thanks for your help!
Thanks for your help!
ASKER
How can I compact and repair?
The second computer is fully updated.
I cannot open design mode, I can get to the code.