Replies to post #34506 on The Question and Answer Board (IHUB)

[Bob Zumbrunnen]

We don't know whether the problem is a connection or recordset. Ensuring that the connection is closed is the first step because it's the easiest, and I included closing rs since that's the recordset name I use the most.

 
 if typename(rs)="Recordset" then 
 	if rs.state=1 then 
 		rs.close 
 	end if 
 	set rs=nothing 
 end if 
 if typename(my_conn)="Connection" then 
 	if my_conn.state=1 then 
 		my_conn.close 
 	end if 
 	set my_conn=nothing 
 end if 
 

Have to do it this way because if rs is already destroyed or closed, rs.close will return an error.