Isn't enought memory error on new subform

I'm design a new subform the will display continuous records.  Now I getting the not enough memory error even when I try to go into design view.  There is only one record in the table the subform references.  

I'm using W7 and the error occurs when I try to access the from in either O2003 or O2010.  Is there a way I can get around the error and get into the form using design view so I can fix whatever the problem is?
JudithARyanTech SupportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Most likely the form is corrupted.  Try compact, try /decompile, try creating a new empty db and importing all the objects.
John TsioumprisSoftware & Systems EngineerCommented:
You need to decompile your application....Probably you have some kind of error that was not picked up when you closed the app.
You just start Ms Access with decompile switch ...e.g for Access 2007
C:\"Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" /decompile

Open in new window

Jeffrey CoachmanMIS LiasonCommented:
In some cases, you will need to delete, ..then recreate the form...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

JudithARyanTech SupportAuthor Commented:
I just tried compact, no joy.  

I haven't tried the new database and import objects yet.

When I tried the decompile, I got the message that the syntax was wrong.  I used the one that John T. showed me.  Is it different for A2010?


The syntax John posted assumes you have A2007.  You need to use the path for your installation of Access.  Essentially, the example is starting access with the /decompile switch but not specifying a database.  Access opens, you pick a database, and then it decompiles.  I can't say that this works since it isn't the method I use.  Since Access is registered to open .accdb files, I don't bother with the path to Access at all.  I just start what ever app I want to decompile.

C:/f1/f2/appname.accdb /decompile

Just use the full path to your access app.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Since Access is registered to open .accdb files, I don't bother with the path to Access at all.
I've found this troublesome on my machine, since at times that syntax will open 2007 or 2010, instead of 2013 (which is my main development version). Once that happens, you get the annoying "Please wait, installing blah blah" situation, which means I have to cancel it, and then close down all of my Access windows, and restart them to insure I don't have issues.

If you're only running a single version of Access on the machine you're okay with doing this, of course.
JudithARyanTech SupportAuthor Commented:
Thanks, guys.  After considering everything, I decided to redo the form.  I'm save each step, so if it happens again maybe I'll have some idea of what I'm doing wrong.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.