Access Database Design and Programming, Second Edition

DBEngine Object

Collections

Property	Type	Version	Description
Errors	Errors	3.0./3.5	Collection of errors from the most recently failed DAO operation
Properties	Properties	3.0/3.5	Collection of Property objects
Workspaces	Workspaces	3.0/3.5	Collection of open Workspace objects

Methods

Method	Parameters	Returns	Version	Description
BeginTrans		Sub	3.0/3.5	Begins a new transaction
CommitTrans		Sub	3.0	Ends the transaction and saves any changes
CommitTrans	[Option as Long]	Sub	3.5	Ends the transaction and saves any changes
CompactDatabase	SrcName As String, DstName As String, [DstConnect], [Options], [SrcConnect]	Sub	3.0	Compacts a closed database
CompactDatabase	SrcName As String, DstName As String, [DstLocale], [Options], [SrcLocale]	Sub	3.5	Compacts a closed database
CreateDatabase	Name As String, Connect As String, [Option]	Database	3.0	Creates a new database
CreateDatabase	Name As String, Locale As String, [Option]	Database	3.5	Creates a new .MDB database
CreateWorkspace	Name As String, UserName As String, Password As String	Workspace	3.0	Creates a new Workspace object
CreateWorkspace	Name As String, UserName As String, Password As String, [UseType]	Workspace	3.5	Creates a new Workspace object
Idle	[Action]	Sub	3.0/3.5	Completes pending engine tasks such as lock removal
OpenConnection	Name As String, [Options], [ReadOnly], [Connect]	Connection	3.5	Opens a connection to a database
OpenDatabase	Name As String, ...