A Databases collection contains all open CdbDatabase objects opened or created in a CdbWorkspace object.
Remarks
When you open an existing CdbDatabase object or create a new one from a CdbWorkspace, it is automatically appended to the Databases collection. When you close a CdbDatabase object with the Close method, it is removed from the Databases collection, but not deleted from disk. Close all open CdbRecordset objects before closing a CdbDatabase object.
In a Microsoft Jet workspace, the Name property setting of a database is a string that specifies the path of the database file. In an ODBCDirect workspace, the Name property is the name of the corresponding CdbConnection object.
To refer to a CdbDatabase object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:
Databases[0]
Databases["name"]
Note You can open the same data source or database more than once, creating duplicate names in the Databases collection. To avoid confusion, assign CdbDatabase objects to object variables and refer to them by variable name.