Microsoft Access - ODBC Drivers error - Too many client tasks

[sampath]

While a user tries to log, with Internet Explorer, onto a
MS ACCESS database application , which uses IIS and Active
Server Pages, the following error comes:

Microsoft OLE DB Provider for ODBC Drivers error 80040e
[Microsoft] [ODBC Microsoft Access Driver] Too many client
tasks.

 

[Jim Gordon MVP]

Hi,

Microsoft Access allows up to 10 concurrent connections of "clients" at
a given time.

If you know that fewer than 10 connections are being used, then it is
necessary to tell Access to close unused connections. Other newsgroup
postings suggest:

" connections to you database open. Make sure you close all your
connections. If you are using recordsets for queries, try settind
RS.ActiveConnection = Nothing."

-Jim