In the above snippet, which of the dim'd vars should be set to Nothing
at the end of their usefulness? For example, I'm unsure if setting
MyDB to Nothing at the end really accomplishes anything at all.

In the above snippet, which of the dim'd vars should be set to Nothing at the end of their usefulness? For example, I'm unsure if setting MyDB to Nothing at the end really accomplishes anything at all.

You shouldn't "have" to set any of them to nothing. Because that doesn't
always work as advertised the usual advice is to set them all to nothing in
the reverse order that they are dimmed.

In the above snippet, which of the dim'd vars should be set to Nothing at the end of their usefulness? For example, I'm unsure if setting MyDB to Nothing at the end really accomplishes anything at all.

You shouldn't "have" to set any of them to nothing. Because that doesn't always work as advertised the usual advice is to set them all to nothing in the reverse order that they are dimmed.

And all recordset variables should be closed before setting them to
Nothing, as well as any database variable that is pointing to
anything other than the MDB currently open in the Access UI.