What is the difference between the three Set lines below?
And should either/both of these lines be at the end of a routine that uses the OpenDatabase method?
Code:
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?
Code:
Set db = nothing
db.close