>
Workspaces Collection
Description
The Workspaces collection contains all active, unhidden Workspace objects of the DBEngine object. (Hidden Workspace objects are not appended to the collection and referenced by the variable to which they are assigned.)
Remarks
Use the Workspace object to manage the current session or to start an additional session.
When you start the Microsoft Jet database engine, you automatically create the default workspace, DBEngine.Workspaces(0).
New Workspace objects are created with the CreateWorkspace method of the DBEngine object. After you create a new Workspace object, you must appended it to the Workspaces collection if you need to refer to it from the Workspaces collection. You can, however, use a newly created Workspace object without appending it to the Workspaces collection.
You can refer to any other Workspace object that you create and append to the collection by its Name property setting using this syntax:
Workspaces("name")
You can also refer to appended Workspace objects by their position in the Workspaces collection using this syntax (where n is the nth member of the Workspaces collection):
DBEngine.Workspaces(n)
Properties
Count Property.
Methods
Append Method, Refresh Method.
See Also
Appendix, "Data Access Object Hierarchy."
Example
See the Workspace object example.