Workspace Members (DAO)

Office 2013 and later

Last modified: March 09, 2015

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.

Name

Description

BeginTrans

Begins a new transaction. Read/write Database.

Close

Closes an open Workspace.

CommitTrans

Ends the current transaction and saves the changes.

CreateDatabase

Creates a new Database object, saves the database to disk, and returns an opened Database object (Microsoft Access workspaces only).

OpenConnection

Note 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).

OpenDatabase

Opens a specified database in a Workspace object and returns a reference to the Database object that represents it.

Rollback

Ends the current transaction and restores the databases in the Workspace object to the state they were in when the current transaction began.

Name

Description

Connections

Returns a Connections collection that represents the current connections in the specified Workspace. Read-only.

Databases

Returns a Databases collection that represents the open databases in the specified Workspace. Read-only.

DefaultCursorDriver

Note 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).

IsolateODBCTrans

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).

LoginTimeout

Sets or returns the number of seconds before an error occurs when you attempt to log on to an ODBC database.

Name

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.

Properties

Returns the Properties collection of the specified object. Read-only.

Type

Sets or returns a value that indicates the operational type or data type of an object. Read-only Integer.
Show: