OpenDatabase method differences (1 Viewer)

[tomasm]

What is the difference between the three Set lines below?

Dim db As DAO.Database

Set db = OpenDatabase("C:\Northwind.accdb")
Set db = DBEngine(0).OpenDatabase("C:\Northwind.accdb")
Set db = DBEngine.WorkSpaces(0).OpenDatabase("C:\Northwind.accdb")

And should either/both of these lines be at the end of a routine that uses the OpenDatabase method?

Set db = nothing

db.close

 

[arnelgp]

no difference, just different flavor and all points to Currentdb.
use Codedb, that one is different.

 

[The_Doc_Man]

There are arguments to be made for using

db.close
set db = nothing

in that order IF it is your plan to continue by opening another DB after you close this one.

As to the three ways you showed to open the DB, they are the same because of defaults. The default reference is to DBEngine(0) and to Workspaces(0), so when you omit the explicit references, they are still there implied as defaults.