Not enough Free Memory Error

[Catrina]

While I was working on my database, I would occasionally get the error &quot;Not enough free memory to display screen&quot; (or something like that), and I would lose anything I hadn't saved. It happened when I had been working on it for long periods of time, and I figured it was just my computer, but now that it is finished, it happened again on another computer when someone was entering data for a long period of time. Does anyone know why I am getting this error, or how to stop it?<br><br>I am using Access 2000 on a Win98 computer. The database has 6 tables, 7 queries and 10 forms. <br><br>I was wondering if I should be unloading the forms rather than closing them. I used the command button wizard to make the exit buttons on each form which creates Docmd.Close, I'm familiar with VB, but just learning how to use it with Access. The Main Menu form is always open behind the called forms. Thanks in advance for any help.<br><br>Catrina

 

[xtreme1]

You might want to post an exact error, &quot;or something like that&quot; isn't exact...=]&nbsp;&nbsp;Does it say &quot;Disk or Network Error&quot;, &quot;Out of Disk Space&quot;, etc.&nbsp;&nbsp;I'm not sure if I'll be able to help you with this problem, but for someone else to be able too you might want to give them that message...it's very hard to troubleshoot &quot;maybe's&quot;.&nbsp;&nbsp;=]&nbsp;&nbsp;Good luck on your search! <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>

 

[Catrina]

Thanks anyway, but I searched for &quot;Not enough free memory&quot; on the MS web site and found out I need to download a fix. I guess &quot;Not enough free memory&quot; was enough information after all.<br><br>Catrina

 

[cmmrfrds]

If the fix does not work there are a couple of other considerations.<br><br>One, if this application was converted from Access 97 then it may be retaining vba code in memory. This happened to me and I had to create a fresh Access 2000 mdb and import everything from the old.<br><br>Another possiblity is if you used other than &quot;standard color&quot; when generating forms with the wizard. There is a bug when using the other colors.<br><br>There was a post recently where somebody ran into this problem.<br><br>Jerry

 

[Catrina]

The database was created using Access 2000. The colors were the problem, but the download is suppose to fix it, haven't downloaded it yet as the site said it would take a long time and suggested doing it overnight. I will post here if it corrects the problem.<br><br>Catrina

 

[HIM]

Another problem which can create this error, is if you use the predefined styles that come with Access 2000.<br>Try and remove these styles. This is documented on msdn.microsoft.com