PRB: Error "Too many client tasks" When Using Jet

This article was previously published under Q154869
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
When trying to use the database features of Visual Basic, you may receivethe error message "Too many client tasks." This occurs when more than 10applications running on the same machine try to use the Jet databaseengine.
CAUSE
The Jet database engine versions 1.1, 2.0, and 2.5 can only be used by 10client applications simultaneously on any one machine.
WORKAROUND
It is not possible to have more than 10 client applications making use ofthe 16-bit Jet database engine on one machine. If it is essential that asoftware system have more than 10 executables on the same machine withaccess to one or more databases, the system could be designed with one"server" exe accessing the database and multiple "client" programs makingrequests for data from this "server" via an inter-process communication(IPC) mechanism. For example, with Visual Basic version 4.0, this could beachieved using OLE automation.
STATUS
This behavior is by design.

(This is not an issue with Jet 3.0 as used by Visual Basic 4.0 32-bit.)
REFERENCES
Visual Basic Online Help.
4.00 vb4win vb416 kbuk
Eigenschappen

Artikel-id: 154869 - Laatst bijgewerkt: 12/04/2015 15:13:33 - Revisie: 3.0

  • Microsoft Visual Basic 4.0 Professional Edition
  • Microsoft Visual Basic 4.0 Professional Edition
  • Microsoft Visual Basic 4.0 16-bit Enterprise Edition
  • Microsoft Visual Basic 4.0 32-Bit Enterprise Edition
  • kbnosurvey kbarchive kbprb KB154869
Feedback