A fraction of users receive this error when completing an ASP survey. Is this a coding error, or have we reached our maximum user limit?
We have about 200 users trying to access, and about 180 have no problem with this same page, but the rest get the error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The request for procedure 'tblResultsIncoming' failed because 'tblResultsIncoming' is a table object.
' create recordset object
Set objRst = Server.CreateObject("ADODB.RecordSet")
objRst.Open "tblResultsIncoming", dbCONN, 1,4
I'm a network geek, not a db expert, so please forgive if I've said anything dumb or left anything out.
We're running this on a fast dual-processor server with 1 GB memory. Thanks!