Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Access 2013, Office 2013
A Workspace object defines a named session for a user. It contains open databases and provides mechanisms for simultaneous transactions and, in Microsoft Access workspaces, secure workgroup support.
Methods
Name |
Description |
|---|---|
Begins a new transaction. Read/write Database. |
|
Closes an open Workspace. |
|
Ends the current transaction and saves the changes. |
|
Creates a new Database object, saves the database to disk, and returns an opened Database object (Microsoft Access workspaces only). |
|
NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Opens a Connection object on an ODBC data source (ODBCDirect workspaces only). |
|
Opens a specified database in a Workspace object and returns a reference to the Database object that represents it. |
|
Ends the current transaction and restores the databases in the Workspace object to the state they were in when the current transaction began. |
Properties
Name |
Description |
|---|---|
Returns a Connections collection that represents the current connections in the specified Workspace. Read-only. |
|
Returns a Databases collection that represents the open databases in the specified Workspace. Read-only. |
|
NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Sets or returns the type of cursor driver used on the connection created by the OpenConnection or OpenDatabase methods (ODBCDirect workspaces only). |
|
Sets or returns a value that indicates whether multiple transactiond that involve the same Microsoft Access database engine-connected ODBC data source are isolated (Microsoft Access workspaces only). |
|
Sets or returns the number of seconds before an error occurs when you attempt to log on to an ODBC database. |
|
Returns or sets the name of the specified object. Read/write String if the object has not been appended to a collection. Read-only String if the object has been appended to a collection. |
|
Returns the Properties collection of the specified object. Read-only. |
|
Sets or returns a value that indicates the operational type or data type of an object. Read-only Integer. |