ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   difference Close and Nothing in query (https://www.excelbanter.com/excel-programming/357546-difference-close-nothing-query.html)

x taol

difference Close and Nothing in query
 


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 ***

Mike Fogleman

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 ***





All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com