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. beginTrans() | |
commitTrans() | |
compactDatabase() | |
createDatabase() | |
createWorkspace() | |
defaultPassword | |
defaultType | |
defaultUser | |
errors | |
idle() | |
iniPath | |
loginTimeout | |
openConnection() | |
openDatabase() | |
properties | |
registerDatabase() | |
rollback() | |
setOption() | |
version | |
workspaces |
DBEngine
has the three methods beginTrans
, commitTrans
and rollback
with which transactions are possible. See here. application.currentDb()
is equivalent to: dbEngine.workspaces("#Default Workspace#").databases(0)
dbEngine.workspaces(0).databases(0)
dbEngine(0).databases(0)
dbEngine(0)(0)
SystemDB
contains the path of the workgroup information file, for example C:\Users\username\AppData\Roaming\Microsoft\Access\System1.mdw
.