Re: There isn't enough memory? -- cannot open form
From: Darrell Wesley (DarrellWesley_at_discussions.microsoft.com)
Date: 08/17/04
- Next message: Kamyk: "Re: Problem with sending appointment"
- Previous message: Allen Browne: "Re: Access 2003 form designed in Access 2000 hung up on calculating"
- In reply to: Sandra Daigle: "Re: There isn't enough memory? -- cannot open form"
- Next in thread: Ernie: "Re: There isn't enough memory? -- cannot open form"
- Reply: Ernie: "Re: There isn't enough memory? -- cannot open form"
- Reply: Sandra Daigle: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 08:51:04 -0700
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: Kamyk: "Re: Problem with sending appointment"
- Previous message: Allen Browne: "Re: Access 2003 form designed in Access 2000 hung up on calculating"
- In reply to: Sandra Daigle: "Re: There isn't enough memory? -- cannot open form"
- Next in thread: Ernie: "Re: There isn't enough memory? -- cannot open form"
- Reply: Ernie: "Re: There isn't enough memory? -- cannot open form"
- Reply: Sandra Daigle: "Re: There isn't enough memory? -- cannot open form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
