Re: There isn't enough memory? -- cannot open form
From: Sandra Daigle (Invalid_at_KeepYourSpam.org)
Date: 08/18/04
- Next message: Douglas J. Steele: "Re: Substituting my own MsgBox for the standard delete confirm MsgBox"
- Previous message: StCyrM: "Re: Hosting WebBrowser control (shdocvw.dll) in Access form"
- In reply to: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Aug 2004 08:48:01 -0400
Hi Darrell,
When you tried the SaveAsText where were you? Had you tried to open the form
first? Try this - close the database then reopen it and open the VB Editor.
Try running the code that issues the SaveAsText/LoadFromText. Does it work
when nothing else is open?
One other thing that I've seen happen is that the mdb is corrupt in such a
way that the form object has been deleted but the associated class module is
not - you can't see it or get to it but it interferes in ways such as what
you've already described. You can try creating a brand new form, saving it
under the name of the problem form. Then decompile/compact/decompile. At
this point, it's trial and error but you're trying to get the old module
associated with the new form so you can get rid of both of them and start
over. I've had limited results solvoing this particular problem.
For grins, make a copy of your last known good backup. In the copy rename
the problem form. Then in the db you're trying to salvage import the renamed
form. Does it work?
-- Sandra Daigle [Microsoft Access MVP] Please post all replies to the newsgroup. Darrell Wesley wrote: > I've now tried "decompile" with no success. I've tried to do a > "SaveAsText" and the only thing I get is a error 2001 "You cancelled > the previous operation" --- don't have a clue as to what operation > was cancelled but that's what it says. > > Now what? > > "Sandra Daigle" wrote: > >> Hi Darrell, >> >> This does sound like corruption in the VBA project. There are >> several things you can try that might fix the problem. First make >> and keep a backup of the corrupt database. Also locate the most >> recent backup you have of the non-corrupt project. You may have to >> resort to it if all else fails. >> >> Try decompiling the database. Here are a couple of links on >> decompile. They are written for Access97 but the same method works >> for Access2000. Be sure to make a copy of your mdb before you >> decompile. I've never had any trouble but you never know. >> >> http://www.mvps.org/access/bugs/bugs0008.htm >> http://www.trigeminal.com/usenet/usenet004.asp >> >> FWIW I usually Decompile, compact then decompile again. >> >> Try saving the form as text, then loading it back from text. There >> is an undocumented way of doing this (meaning use at your own risk!) >> >> Application.SaveAsText acForm, strFormName, strDestPath >> Application.LoadFromText acForm, strFormName, strSourcePath >> >> For example: >> >> Application.SaveAsText acForm, "FormA", "c:\temp\FormA.txt" >> Application.LoadFromText acForm, "FormA2", "c:\temp\FormA.txt" >> >> I've successfully used this as a method for repairing a corrupt form >> object. >> >> Try Jackie's suggestion of creating a new form and copying the >> controls from the old form into the new one. >> >> If all of the above fail take a look at Tony's page on corruption - >> http://www.granite.ab.ca/access/corruptmdbs.htm. >> >> -- >> Sandra Daigle [Microsoft Access MVP] >> Please post all replies to the newsgroup. >> >> >> Darrell Wesley wrote: >>> I have a database that was created by someone else that is now >>> having corruptions taking place. The corruption does not appear to >>> be data related but rather Forms related. >>> >>> There are 2 forms that when I try to open them up I get the error >>> message "There isn't enough memory to perform this operation. Close >>> unneeded programs and try the operation again." If I open a new >>> database and attempt to import these 2 forms Access informs me that >>> either the object name is spelled wrong or the object does not >>> exist. >>> >>> Does anyone have an idea as to the problem?
- Next message: Douglas J. Steele: "Re: Substituting my own MsgBox for the standard delete confirm MsgBox"
- Previous message: StCyrM: "Re: Hosting WebBrowser control (shdocvw.dll) in Access form"
- In reply to: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
