ADO 3705 error - Need Help Fast!!

[janrussell]

I'm getting an ADO error 3705 (The operation requested by the application is not allowed if the object is open.)at run-time with my application. It runs a stored procedure that builds a temp table. From this temp table and 2 other tables, a select is made and the results are displayed using the data designer. I've tested on numerous machines numerous times before giving it to a client. When it is run there, we get the message above. Can someone please provide some insight on what I might need to look at????? Quickly???

 

[MarkSweetland]

Short term fix may be to insert a close statement before each Open call:

If rs.State = adStateOpen Then rs.Close
rs.Open strSQL, ....


Mark