The Workspace Object and the Workspaces Collection

The Workspace object represents an ODBCDirect workspace. The Workspaces collection contains the set of all active ODBCDirect workspaces. The following table shows the relationship between the Workspace object and the Workspaces collection and other objects and collections in an ODBCDirect workspace.

Object or collection Is contained by Contains
Workspace object Workspaces collection Connections collection
Databases collection
Properties collection
Workspaces collection DBEngine object Workspace objects

The first step in using ODBCDirect is to create an ODBCDirect workspace with the CreateWorkspace method. The ODBCDirect workspace routes calls directly to the ODBC application programming interface (API), as opposed to the Microsoft Jet workspace, which first routes calls to the Microsoft Jet database engine, and then to the ODBC API when you’re using ODBC.