Does destroying the ADO Connection close the database?
 

Yes, that's pretty much it.
Richard Choate

"Tod" wrote in message
...
Here's my newbie ADO question.

My code uses ADO to query an Access database. It's
basically like this:

cn.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=" &
ThisWorkbook.Path & "\DatabaseName.mdb;"

Sql = "SELECT * From TableName"

rs.Open Sql, cn

'Do stuff with the recordset

rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing

If I watch Windows Explorer while this code is running, I
see the file being created that says the database is in
use, then see it go away to indicate the database is
closed.

My question is this. Am I doing all I need to do by
closing the connection and destroying the object?

tod