Link to home
Start Free TrialLog in
Avatar of andybrooke
andybrooke

asked on

Access out of memory error

Hi,

I get  the error as below on a few machines running a database. All machines have enough memory free. This has just happened on my mahcines that when I checked have 2GB free out of 4GB. I'm thinking that access has a memory allocation it give itself which is getting full?

How can I stop this from happening.

Thanks
error.JPG
Avatar of jppinto
jppinto
Flag of Portugal image

This can be a file corruption problem. Try creating a new blank database and copy all of the objects to this new one a try it again. Also make a Compact and Repair first to see if it solves the problem (make a backup copy first!).

jppinto
ASKER CERTIFIED SOLUTION
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of paultantony
paultantony

what version of msaccess are you using? If it a older version like 95/97 their is a limitation on the size of the mdb file. compact the mdb using the options under the database menu