I am always amazed at how many ways there are of writing code that produces the same end. Help me to understand the difference in the following lines:
Set db = DBEngine(0)(0)
db.Execute "QueryName", dbFailOnError
Set db = Nothing
CurrentDb.Execute "QueryName", dbFailOnError
Other than the apparent briefness of the one line over three is one better than the other?
What is Set db = Nothing?