Re: There isn't enough memory? -- cannot open form
From: Sandra Daigle (Invalid_at_KeepYourSpam.org)
Date: 08/17/04
- Next message: Eric Blitzer: "Memory error, Please help"
- Previous message: Darrell Wesley: "RE: There isn't enough memory? -- cannot open form"
- In reply to: Darrell Wesley: "There isn't enough memory? -- cannot open form"
- Next in thread: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Reply: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 10:03:12 -0400
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: Eric Blitzer: "Memory error, Please help"
- Previous message: Darrell Wesley: "RE: There isn't enough memory? -- cannot open form"
- In reply to: Darrell Wesley: "There isn't enough memory? -- cannot open form"
- Next in thread: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Reply: Darrell Wesley: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
