 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Form does not open in design view
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.  Signaturethadi 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 [quoted text clipped - 14 lines] > for > your input. ...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? Signaturethadi > A point of clarification ... > [quoted text clipped - 33 lines] > > for > > your input. 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. > [quoted text clipped - 55 lines] >> > for >> > your input. > Do an on-line search for MSAccess/decompile for instructions. > [quoted text clipped - 71 lines] > > - 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. 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 SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.