Bad Form!!!! Please help!!!

E

Emma Hope

I have a form in my Access 2003 database which opened quite happily before
and won't now. The error message is '2004 there isn't enough memory to
perform the operation....'. I have Access 2003 with SP2. I have tried copying
the form, copying it from an old copy of the database, renaming, changing the
query, going into the VBA and trying to delete this, i have tried just about
everything and each time i get the same error message.

I really really need to get my database released today and this suddenly
happens and i can't do anything to stop it. PLEASE help!!!!
 
A

Allen Browne

Emma, if the form is really bad, this may not work but it's worth a shot to
try exporting it to a text file, and then reimporting it.

1. Open the Immediate Window (Ctrl+G).

2. Enter this:
SaveAsText acForm, "Form1", "C:\MyPath\Form1.txt"
substituting the name of your form for Form1, and some path where the file
can save to instead of MyPath.

3. Delete the form.
(You're doing this in a *copy* of the database of course, so you still have
your original if this doesn't work.)

4. Compact the database.

5. Enter this in the Immediate window:
LoadFromText acForm, "Form1", "C:\MyPath\Form1.txt"

This undocumented approach just might rescue the form for you.
 
U

Ultimateace

Allen you are a pure undisputed genius! (and if i wasn't already married to a
beautiful woman I would marry you!) Worked wonderful!
 
A

Allen Browne

Good news! Thanks for sharing.

The SaveAsText/LoadFromText is really useful when it does work.
 
Top