ODBC Microsoft Access Driver] Too many client tasks

[clivehenderson]

Hello
Can anyone help with this problem which I get after creating about 60 reords? (I need to create hundreds in a setup procedure)

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

I'm developing using MsAccess but transfer to a MYSQL database for live running. I'm also using a connection string.

The code I'm using is as follows in a loop.

set rsMatch = Server.CreateObject("ADODB.Command&quot
rsMatch.ActiveConnection = MM_Squash_STRING
rsMatch.CommandText = "insert into tblMatch (MatchID,HomeTeamID,AwayTeamID,MatchDate) values (" & intMatchNumber & "," & arrTeams(intHome) & "," & arrTeams(intAway) & "," & datMatch & &quot"
rsMatch.Execute
Set rsMatch = nothing

These are the strings I use for MYSQL and access

MM_Squash_STRING = "Driver={MySQL};db=adbname;uid=ausername;pwd=apassword"
MM_Squash_STRING = "dsn=Squash;"

I've tried tried a dsnless connection as below with same result
Provider=MSDASQL; Driver={Microsoft Access Driver (*.mdb)}; Dbq=c:/data/adbname.mdb

Any help/pointers appreciated.
Thanks
Clive