>thanks for the response John. What is the code to close the cursorname and deallocate it for Sql Server?


close = "Close curName"
deallocate = "Deallocate curName"

You would have to send those two commmands through ADO, Like executing a non-query.