"There Isn't Enough free memory"Error when working with a form page

[Learningaccess]

Once I go into DESIGN VIEW on any form the Resource Meter goes down and eventually gives the above message. My machine is Peniun lll with 10gibytes so I figure that it can handle this database. What is the solution?

 

[Learningaccess]

Sorry, it's Access 2000

 

[DougP]

The size of your hardrive has nothing to do with it. How much Memory (RAM) do you have thats the &quot;32&quot; or &quot;64&quot; or &quot;128 number?<br>
Access 2000 needs all the power you can give her &quot;Scotty&quot;.<br>
The solution is addmore RAM.<br>
Also look in Explorer and see how big the .MDB file is you are opening.<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[Learningaccess]

ram=128<br>
The size of the file=580804kb

 

[DougP]

Thats your problem to big a file for the amount of RAM<br>
Increase your RAM <br>
Now have you ever &quot;Compacted&quot; the .MDB????<br>
First make a backup copy of the .MDB file.<br>
Then Open Access 2000<br>
Open the database .mdb<br>
click the &quot;Tools&quot; menu then &quot;Data Base Utilities&quot;<br>
Then click &quot;Compact and Repair database&quot; this will take a while<br>
If you have corruption in the VBA code it will ruin the .MDB, thats why you made a copy to go back to.<br>
If all goes well your .MDB should be considerably smaller. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>