out of memmory

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!
sunrajAsked:
Who is Participating?
 
wyy_cqConnect With a Mentor Commented:
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
 
raybCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.