Search notes:

Access Object Model: DBEngine

DBEngine it the top level object of the DAO object hierarchy. The object is a singleton, thus, it's always present and no second DBEngine object can be created.

Properties and methods

beginTrans()
commitTrans()
compactDatabase()
createDatabase()
createWorkspace()
defaultPassword
defaultType
defaultUser
errors
idle()
iniPath
loginTimeout
openConnection()
openDatabase()
properties
registerDatabase()
rollback()
setOption()
version
workspaces

Transactions

DBEngine has the three methods beginTrans, commitTrans and rollback with which transactions are possible. See here.

Finding the current database

Apparently, application.currentDb() is equivalent to:

SystemDB

The value of SystemDB contains the path of the workgroup information file, for example C:\Users\username\AppData\Roaming\Microsoft\Access\System1.mdw.

See also

The Database object.
Access Object Model

Index