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
andybrookeAsked:
Who is Participating?
 
MINDSUPERBConnect With a Mentor Commented:
andybrooke,

Have check the similar thread below. This might be helpful to solve the issue.


http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26458695.html

Sincerely,

Ed
0
 
jppintoCommented:
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
0
 
paultantonyCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.