Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access out of memory error

Posted on 2010-09-09
4
Medium Priority
?
357 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

772 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