View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default difference Close and Nothing in query

The first closes the actual database file, the second empties the value
assigned to the variable "db".

Mike F
"x taol" wrote in message
...


for example
dim db as dao.database
....
....
db.Close
set db = Nothing

i want to know that difference of upper 2 code.

*** Sent via Developersdex http://www.developersdex.com ***