how to close down a query

When I write the code for a query using adodb I can clear it after use by using something like

Please Login or Register  to view this content.

I have been working with Sage Line100 which does not seem happy with recordsets and have therefore used ODBC and Querytables instead.
Can any one help me with shutting down such a query. Code such as

Please Login or Register  to view this content.

Although it does not cause an error, does not work so the number of named corrections grows as the application is used.
What should I using to clear the query after it has been used

Norie, this is what I have been trying

Please Login or Register  to view this content.