DBEngine members (DAO)

Applies to: Access 2013, Office 2013

The DBEngine object is the top level object in the DAO object model.

Methods

Name	Description
BeginTrans	Begins a new transaction. Read/write Database.
CommitTrans	Ends the current transaction and saves the changes.
CompactDatabase	Copies and compacts a closed database, and gives you the option of changing its version, collating order, and encryption. (Microsoft Access workspaces only). .
CreateDatabase	Creates a new Database object, saves the database to disk, and returns an opened Database object (Microsoft Access workspaces only). .
CreateWorkspace	Creates a new Workspace object.
Idle	Suspends data processing, enabling the Microsoft Access database engine to complete any pending tasks, such as memory optimization or page timeouts (Microsoft Access workspaces only).
OpenConnection	One of the WorkspaceTypeEnum values.	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 and returns a reference to the Database object that represents it.
RegisterDatabase	Enters connection information for an ODBC data source in the Windows Registry. The ODBC driver needs connection information when the ODBC data source is opened during a session.
Rollback	Ends the current transaction and restores the databases in the Workspace object to the state they were in when the current transaction began.
SetOption	Temporarily overrides values for the Microsoft Access database engine keys in the Windows Registry (Microsoft Access workspaces only).

Properties

Name	Description
DefaultPassword	Sets the password used to create the default Workspace when it is initialized. Read/write String.
DefaultType	Sets or returns a value that indicates what type of workspace will be used by the next Workspace object created.
DefaultUser	Sets the user name used to create the default Workspace when it is initialized. Read/write String.
Errors	Returns an Errors collection that contains all of the stored Error objects for the specified object. Read-only.
IniPath	Sets or returns information about the Windows Registry key that contains values for the Microsoft Access database engine (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.
Properties	Returns the Properties collection of the specified object. Read-only.
Version	Rreturns the version of DAO currently in use. Read-only String.
Workspaces	Returns a Workspaces collection that contains all of the active, unhidden Workspace objects. Read-only.