How did you create your query in VB?

If you are using the Recordset.Open to execute a SELECT statement you will have to close the recordset yourself, but with the INTO statement the Recordset is closed after is has been executed.

Hope this helps,

Alex Otten