CodingForums.com - View Single Post - sometimes having operation is not allowed when the object is closed error

maxpouliot · 02-09-2012, 05:07 PM

Hi, on this simple code

Code:

SQLRedirect= "SELECT * FROM elementsOutils WHERE id=" & id
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQLRedirect,Conn

I'm having operation is not allowed when the object is closed errors but not all time. It seems to happen when alot of users are opening pages at the same time. users are trying again a couple of seconds later and it's working.

Is it something on the server?

I'm using an access database

02-09-2012, 05:07 PM	PM User \| #1
maxpouliot New Coder Join Date: Mar 2006 Posts: 90 Thanks: 2 Thanked 0 Times in 0 Posts	sometimes having operation is not allowed when the object is closed error Hi, on this simple code Code: SQLRedirect= "SELECT * FROM elementsOutils WHERE id=" & id Set rs = Server.CreateObject("ADODB.Recordset") rs.Open SQLRedirect,Conn I'm having operation is not allowed when the object is closed errors but not all time. It seems to happen when alot of users are opening pages at the same time. users are trying again a couple of seconds later and it's working. Is it something on the server? I'm using an access database