Solved

Out Of Memory Error

Posted on 1998-10-18
6
420 Views
Last Modified: 2013-12-25
Hello fellow Database guru's,
I'm using the VB DataControl to handle a large Access 7 database.

The code works fine on smaller databases, but when I attempt to use it on my large database, setting the recordsource to a SQL statement the system generates:
system error &H800040005 (-2147467259).

The error handling routine in the code shows:
Data error event hit err:Out of memory.

Does anyone know what causes this, and how I can get round it?

Thank you!
0
Comment
Question by:databaseguru
6 Comments
 
LVL 13

Expert Comment

by:Mirkwood
Comment Utility
Which error do you mean
&h80040005  or &h80004005
Most likely the second on E_FAIL.
The system just fails with an unspecified error.

0
 
LVL 2

Expert Comment

by:Veroland
Comment Utility
how big is the database ? and when it chrases how big then. I've had a problem where my DB grew up tot 1 gig while busy doing a query and then crashes. Access can only handle DB's up to a gig
0
 
LVL 5

Expert Comment

by:AnswerTheMan
Comment Utility
u wrote u tried on a smaller database. have u used the same
setting for the recordsource to a SQL statement ?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 3

Expert Comment

by:TheAnswerMan
Comment Utility
Is there a Grid Bound to the Datacontrol?
0
 
LVL 2

Expert Comment

by:kswinney
Comment Utility
Can you post the SQL for your recordsource?  Also, have you tried executing the exact same SQL inside Access 7?

Are you returning a huge number of rows from your query?  If so, try binding your control as a virtual control.  Grids especially consume large amounts of resources trying to fill themselves with entire recordsets.  Virtual binding can avoid this problem.

One more thing:  Consider re-coding your query to return less data based on user input.  

The narrower you make your select statement, the faster your app will run.  When you're binding large recordsets it's especially important.  You probably already know this stuff... but it's usually the cause of the problem you're experiencing.

0
 
LVL 3

Accepted Solution

by:
SPECIALIST earned 200 total points
Comment Utility
download the new MS JET from www.microsoft.com.  It addresses many problems and fixes them.

Good luck

Specialist
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

763 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

10 Experts available now in Live!

Get 1:1 Help Now