Im getting this error '80040e4d' - Too many client tasks

[mymatemark]

Hi there ..

Ive made a dynamic web gallery using ASP and Access. Everything has been fine till the last couple of days. Currently the page generates the following error when it trys to display the images.

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

/default_image_viewer.asp, line 121

Line 121 is the connection to the database. I have double checked that and it appears to be fine ??

Ive searched everywhere and can't find any additional information on the error.

Can anybody help?

Thanks in advance
Mark

 

[cbokowski]

I did a quick search, the couple of things found by doing a google search points to having too many recordsets open or not closing a destroying the object after use.

 

[lobstah]

check to see that you are closing the recordset on your previous open before you try to open it again.