?
Solved

Too many client tasks - What does this DAO error indicate?

Posted on 2004-04-06
2
Medium Priority
?
607 Views
Last Modified: 2013-11-20
Hi there!

I've been writing a database app using MFC (Visual C++ 6.0). It accesses its Microsoft Access database by means of ODBC. I keep on getting the following error: "Too many client tasks. (Error 3053)". This normally happens after I've added about 40 or so new records to the database. What does this indicate?

MSDN explains the error as follows:
You have too many copies of applications running at the same time. Close one or more instances.

That's not much help to me though.

I'm using the class CRecordset and adding records using the AddNew and Update member functions, if that helps.

Hopefully someone had a similar struggle, I hope you can help me out.

Thanx.
Josamoto
0
Comment
Question by:josamoto
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Expert Comment

by:nonubik
ID: 10764851
It seems that you have too many databases opend in the same time. Try to close the database after each opening (for adding a record)
0
 
LVL 15

Accepted Solution

by:
lakshman_ce earned 375 total points
ID: 10766103
while opening the CRecordset which one of the following you are specifying
-snapshot
-dynaset
-dynamic
I would suggest you to specify the CRecordset::dynaset
Also check if you are closing the CRecordset after each use like
// Example for CRecordset::Close

// Construct a snapshot object
CCustSet rsCustSet( NULL );

if( !rsCustSet.Open( ) )
   return FALSE;

// Use the snapshot ...

// Close the snapshot
rsCustSet.Close( );

-Lakshman
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

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…
In this post we will learn different types of Android Layout and some basics of an Android App.
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.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

800 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