[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1561
  • Last Modified:

Access 2003 not enough memory error when opening forms

Apparently our Access 2003 database has gotten damaged.  On some forms when we try to open them I get "not enough memory, close unneeded programs"
On occasion I've been able to import forms from a backup up copy.  However this time I've gone all the way back to a 2007 version and get the same error.  There obviously is something else wrong.  I hope someone has a fix for this.
I've done a compile and a compact and repair.
0
J.R. Sitman
Asked:
J.R. Sitman
  • 6
  • 4
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
A **DeCompile** may help here ...

But first, if you have not already:
Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

mx
0
 
J.R. SitmanAuthor Commented:
Does your reference to .mdb mean frontend or backend?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Do this procedure on you front end.

mx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
J.R. SitmanAuthor Commented:
OK, I did it on a backup copy because the production copy is in use.  Your steps were easy to follow but it didn't help.  Any other suggestion would be appreciated.

Thanks
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Humm ... possibly a system issue.

I hate to ask this, but have you rebooted a system with this issue?

Also ... you can try this
Open any Office app.
From the Help Menu >> Detect and Repair.

not sure what else to add at the moment ...

mx
0
 
J.R. SitmanAuthor Commented:
Most of our users run it via Citrix.  So after your thought of it might be a system problem, I tried it locally, still the same problem.
I did the detect and repair and that didn't help.  So I then opened the database using Access 2007 and got the same error.

If you get a brain storm let me know.
0
 
J.R. SitmanAuthor Commented:
I imported the form into a different version of the database that we designed for another company.  The form works fine, in that version.  When I import it (with a different name) back into the problem version, it fails.  I'm hoping this will give you a clue.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
The only other thing I can think of is this troubleshooting.

First a question:

Does the suspect form(s) have any code behind (a form module) ?

If not ...  then examine the SQL for the form's record source independently. If it is a saved query, try running that query by itself from the query grid ... and see if you get this error.  If it's an SQL statement ... take the SQL can create a query in the query designer ... and run the query ... again to see if you get the error.

IF .. the form does have code ... you need to set a break point at the first place where code would execute ... like for example in the On Open or On Load event ... and single step through until the error occurs ...

Another remote possibility is ... do you have any Conditional Formatting in the forms?

mx
0
 
J.R. SitmanAuthor Commented:
The form does indeed have code behind. Worryingly, I can't open the form in design view either (so I can't see the code). I was able to use Application.SaveAsText to save the form; LoadFromText to load to a different formname gave an error 2001 "You cancelled the previous operation".

The Recordsource is a SQL statement (attached, from the SaveAsText file).

This form does not have conditional formatting, I'm pretty certain (but I can't open the form to see!!!)

I'll keep digging and work with my consultant John Vinson to see what more we can uncover.


RecordSource ="SELECT SafetyNet.ASN, SafetyNet.AnimalNo, SafetyNet.AnimalName, SafetyNet.DateIn"
        ", SafetyNet.DateOut, SafetyNet.SpeciesID, SafetyNet.BreedID, SafetyNet.Children,"
        " SafetyNet.Relinquishment, SafetyNet.Donation, SafetyNet.Comments, SafetyNet.Col"
        "or, SafetyNet.SpayNeutered, SafetyNet.ReturnedHome, SafetyNet.ShelterContact, Sa"
        "fetyNet.FosteredDate, SafetyNet.FosterName, SafetyNet.FosterPhone, SafetyNet.Age"
        ", SafetyNet.ShelterName, SafetyNet.ShelterPhone, SafetyNet.OwnerFirst, SafetyNet"
        ".OwnerLast, SafetyNet.OwnerPhone, SafetyNet.OtherExpense, SafetyNet.SoftSlipASN,"
        " SafetyNet.EndDate, SafetyNet.ActionASN FROM SafetyNet ORDER BY SafetyNet.ASN, S"
        "afetyNet.AnimalNo;"

Open in new window

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<I was able to use Application.SaveAsText to save the form; LoadFromText to load to a different formname gave an error 2001 "You cancelled the previous operation".>

Can you LoadFromText to a NEW database? If so, could you then perhaps import that to your current database?
0
 
J.R. SitmanAuthor Commented:
We never really found the problem.  We had to import the database into a new frontend after we found a working version of the form from an older copy.  I'm not sure what to do about the points.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now