Solved

Access out of memory error

Posted on 2010-09-09
4
348 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

Backup Your Microsoft Windows Server®

Backup 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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now