The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

DBEngine Object Members

Office 2007

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


Bb243600.methods(en-us,office.12).gif BeginTrans Begins a new transaction. Read/write Database.
Bb243600.methods(en-us,office.12).gif CommitTrans Ends the current transaction and saves the changes.
Bb243600.methods(en-us,office.12).gif CompactDatabase Copies and compacts a closed database, and gives you the option of changing its version, collating order, and encryption. (Microsoft Access workspaces only).
Bb243600.methods(en-us,office.12).gif CreateDatabase Creates a new Database object, saves the database to disk, and returns an opened Database object (Microsoft Access workspaces only).
Bb243600.methods(en-us,office.12).gif CreateWorkspace Creates a new Workspace object.
Bb243600.methods(en-us,office.12).gif 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).
Bb243600.methods(en-us,office.12).gif OpenConnection ODBCDirect workspaces are not supported in Microsoft Office Access 2007. 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).
Bb243600.methods(en-us,office.12).gif OpenDatabase Opens a specified database and returns a reference to the Database object that represents it.
Bb243600.methods(en-us,office.12).gif 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.
Bb243600.methods(en-us,office.12).gif Rollback Ends the current transaction and restores the databases in the Workspace object to the state they were in when the current transaction began.
Bb243600.methods(en-us,office.12).gif SetOption Temporarily overrides values for the Microsoft Access database engine keys in the Windows Registry (Microsoft Access workspaces only).


 NameDescription,office.12).gif DefaultPassword Sets the password used to create the default Workspace when it is initialized. Read/write String.,office.12).gif DefaultType Sets or returns a value that indicates what type of workspace will be used by the next Workspace object created.,office.12).gif DefaultUser Sets the user name used to create the default Workspace when it is initialized. Read/write String.,office.12).gif Errors Returns an Errors collection that contains all of the stored Error objects for the specified object. Read-only,office.12).gif IniPath Sets or returns information about the Windows Registry key that contains values for the Microsoft Access database engine (Microsoft Access workspaces only).,office.12).gif LoginTimeout Sets or returns the number of seconds before an error occurs when you attempt to log on to an ODBC database.,office.12).gif Properties Returns the Properties collection of the specified object. Read-only.,office.12).gif Version Rreturns the version of DAO currently in use. Read-only String.,office.12).gif Workspaces Returns a Workspaces collection that contains all of the active, unhidden Workspace objects. Read-only

Community Additions