Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access out of memory error

Posted on 2010-09-09
4
350 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:andybrooke
4 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 33635465
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
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 33635801
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
 
LVL 10

Expert Comment

by:conagraman
ID: 33643486
0
 
LVL 1

Expert Comment

by:paultantony
ID: 33644699
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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question