Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

Not enough memory

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Question Boy - 22 Apr 2008 19:53 GMT
I recently performed the install of Office 2003 SP3, ever since I have been
getting not enough memory errors (never ever happened prior - not once).  Is
there a known issue,  even better a fix?  

Now I can't save the work I just completed!  Oh the joy of doing a job 2, 3
times!

QB
Question Boy - 22 Apr 2008 19:57 GMT
Even worse, now it has crashed and has corrupted the form.  I can't open/edit
it!

Now I have to restart the entire form after 3 days of work.

> I recently performed the install of Office 2003 SP3, ever since I have been
> getting not enough memory errors (never ever happened prior - not once).  Is
[quoted text clipped - 4 lines]
>
> QB
Question Boy - 22 Apr 2008 19:59 GMT
Is ther any way to recover a corrupt form?

> I recently performed the install of Office 2003 SP3, ever since I have been
> getting not enough memory errors (never ever happened prior - not once).  Is
[quoted text clipped - 4 lines]
>
> QB
Larry Linson - 22 Apr 2008 22:19 GMT
> Is ther any way to recover a corrupt form?

The simplest way is to obtain it from your most recent backup.  When I am
"heavy into" development mode, I make a backup copy several times a day --  
determine the timing of your backup copies by the amount of work that you
are willing to repeat.

Save a copy of the failed database as a baseline reference (if none of the
suggestions work, then there are some third-party data recovery operations,
one being http://www.pksolutions.com, paid recovery but free estimate, last
I heard).

Each time, working on a copy of your baseline reference:

1. It is sometimes possible to recover a form by Compact and Repair, I am
told -- I never was able to accomplish it that way, or

2. Decompile and recompile, or

3. Create a new, empty database and import each of the objects from the
corrupted one, or.

4. Use the officially-undocumented Save As Text / Load From Text features.

For more information on #2 or #4, visit the Google Groups newsgroup archive
website and search this, microsoft.public.access.forms,
microsoft.public.access.formscoding, and the USENET newsgroup
comp.databases.ms-access for details.

5. If none of these work, you'll have to punt, er, contact a data recovery
service.  The only one on which I have had consistently good feedback is the
one I referred to earlier, http://www.pksolutions.com.

Larry Linson
Microsoft Office Access
Tony Toews [MVP] - 23 Apr 2008 02:37 GMT
>Is ther any way to recover a corrupt form?

Quite often in A2003 when this happens to me a decompile fixes things.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Alan - 05 May 2008 15:13 GMT
> >Is ther any way to recover acorruptform?
>
[quoted text clipped - 10 lines]
>    Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Hi,

There is a tool called Advanced Access Repair. I have used it to
repair many corrupt Access MDB files on my damaged disks successfully.
Its homepage is http://www.datanumen.com/aar/ Hope this experience
will help.

Alan
Tony Toews [MVP] - 14 May 2008 02:54 GMT
>There is a tool called Advanced Access Repair. I have used it to
>repair many corrupt Access MDB files on my damaged disks successfully.
>Its homepage is http://www.datanumen.com/aar/ Hope this experience
>will help.

You also work for that company.   Posting without disclosing any
connection is highly unethical.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Tony Toews [MVP] - 23 Apr 2008 02:38 GMT
>Now I can't save the work I just completed!  Oh the joy of doing a job 2, 3
>times!

FWIW whenever I take a coffee break or otherwise step away from my
system I go to Windows Explorer and do a copy and paste of the FE MDB.
I might end up with 3 or 4 copies in a day.  Just to fulfill my job
title of Paranoid Pessimist.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.