Hi Guys, I was wondering if anyone has the solution for the following 
problem:

I'm using MS Access 2000, PWS, Win 98. At the moment I'm developing a 
webapp based on ASP and a MS Access DB. Everything seems to work fine 
until I have to execute a few query's in one function. This function first 
checks if the record already exists, if it doesn't is does an insert 
otherwise is wil go on to the next check. This works fine for, let's say, 
30 records (so 30 selects and 30 inserts), but with 50 records or more I 
get the message: Microsoft JET-Database Engine Error '80004005' 
Unspecified Error. The error point to a line in my code where the 
connection to de db is made. But there's nothing wrong with this 
connections otherwise the first few records couldn't be inserted too.

I already installed the latest MDAC version (2.7) en JET OLEDB SP. This 
didn't help.

I use the following connectionstring: 

"Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=d:\project\data\access.mdb;User ID=;Password=;"

When I change te connectionstring to:
"filedsn=D:\projecten\data\ms_access.dsn;DefaultDir=filedsn=D:\projecten\da
ta;DBQ=D:\projecten\data\access.mdb;"  

An other error occurs:

Access Driver:

Microsoft OLE DB Provider for ODBC Drivers fout '80040e4d' 
[Microsoft][ODBC Microsoft Access-driver] Too many client-tasks. 
/_admin/include/ClassDataAccess.asp, line 171 

But when I run my application on my providers webserver. There's no 
problem. Of course there's other software installed on there system. 
Windows 2000 and IIS 5. But still I'm wondering why it goes wrong on my 
system. Does anyone has any suggestions.

Thx in advance.

Greetzzz

Stephan
mailto:Stephan_bussing@h...