Suggestion needed in closing dB at end of the code

[Voyager]

Hi experts,
I was using the below given code to capture data in a table

sub test()
    Dim db
    Dim rst
    Set db = CurrentDb()
    Set rst = db.OpenRecordset("select * from mytable")
.
.
.
.

And close record set and database after getting data updated but I got some information stating the below will be faster

DBEngine(0)(0).openrecordset(“etbl”,dbopendynaset)

It works however I want to know whether I need to close the database at the end of the code. Like

set dB = nothing

Could you suggest?

 

[isladogs]

Using DBEngine won't be any faster.
However using the dynaset type code will be better.

You should close anything you open - both rst and db

However if you use

Set rst=CurrentDb.openRecordset .....

you have one less variable to define, set and later close