[AccessD] There Isn't Enough Free Memory error message

I can't remember ever seeing form corruption in a production
environment, but it is a not uncommon occurrence in a development
environment.  

Charlotte Foust

-----Original Message-----
From: Doug Murphy [mailto:doug at murphyscreativity.com] 
Sent: Friday, October 31, 2003 8:52 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] There Isn't Enough Free Memory error message


Folks,

We just experienced a weird error in a database that has been working
for several years.  This is a product that we distribute as a runtime
and are just getting ready to make a presentation on at a conference.
Last night in putting it on the laptop we got an error message saying
"There isn't enough free memory to update the display. Close unneeded
programs and try again".  I did a quick Google search on this and found
that there is a problem with Access 2000 form with it's picture property
set to a gif image.  This isn't the case in our situation.  We are using
AccessXP, an MDE file in runtime mode.  The form has a small jpeg image
on it.  After playing with the DB for a while, Pressure mounting as the
flight leaves at 8:00 the next morning, I found that the opeing splash
screen that runs some initialization code was corupted.  I copied the
form components and code into a new form and it seems to be working.

We have not changed this form for quite a while and having it all of a
sudden corrupt doesn't give me a warm fuzzy for something we send to
folks to install on their computers.  I retested the new install on all
the versions and permutations of WindowsXP with and without Office XP
that we have on our test systems.  So far it seems to be working.  Has
any one else had an experience like this?  Any suggestions for
preventing this type of behavior?  With a database that is under
continual development, would it be a good practice to import all objects
into a new container every so often to prevent this type of behavior?

Thanks for any thoughts.

Doug







_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com