Solved

out of memmory

Posted on 1998-11-09
2
224 Views
Last Modified: 2013-11-20
hi! regards!

My application is based on VC++5.0 with back end as Ms-access 97
database. While accessing records from database from the application
MS-ACCESS 97 is giving 'out of memmory' because of too much records.

After deletion of those records, the application works smoothly.

but i need to have lot of records. Any fine tuning is required.
if so, kindly suggest me. Advance thanks!
0
Comment
Question by:sunraj
2 Comments
 
LVL 2

Expert Comment

by:rayb
ID: 1324434
You'll probably need to provide more information...
I don't have any idea which database access model you are using, i.e. DAO, ODBC, ADO, but from the information that you've provided, I would suspect that you may be using a cursor type which is sucking up the memory by fetching too many rows at a time.
0
 
LVL 2

Accepted Solution

by:
wyy_cq earned 20 total points
ID: 1324435
Change the DB Engine . =)

an other way :
select the record out and put them into file.
you may select a part of records every time.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Include multiple hostnames in this command? 3 55
VBA "SendKeys" Syntax for Multiple Keystrokes 7 108
centeredAverage challenge 8 163
sum67 challenge 35 97
Introduction: Hints for the grid button.  Nested classes, templated collections.  Squash that darned bug! Continuing from the sixth article about sudoku.   Open the project in visual studio. First we will finish with the SUD_SETVALUE messa‚Ķ
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 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