About optionality of a collection object name

At creation of a new collection object the parameter that defines the object being created is optional. For example,

Dim engine As dbEngine, wspace As Workspace
Set engine = new dbEngine
Set wspace = engine.CreateWorkspace()

Last code line creates a new instance of the object Workspace and adds it to the Workspace collection of engine. At that the object’s name is not specified.

Getting access to such an object is possible by reference or by index in the collection. However, an unnamed object cannot be added to a database. To be added to a database it needs naming by using the property Name.

See Also

CreateField Method, CreateIndex Method, CreateParameter Method, CreateProperty Method, CreateQueryDef Method, CreateRelation Method, CreateTableDef Method, CreateWorkspace Method