Database
object seems to encapsulate the tables, forms, queries etc. of an Access (.accdb
) file. .accdb
is returned by application.currentDb()
. Database
object belongs to DAO rather than Access. close() | |
collatingOrder | |
connect | |
connection | |
containers | |
createProperty() | |
createQueryDef() | |
createRelation() | |
createTableDef() | |
designMasterID | |
execute() | |
makeReplica() | |
name | |
newPassword() | |
openRecordset() | |
populatePartial() | |
properties | |
queryDefs | |
queryTimeout | |
recordsAffected | |
recordsets | |
relations | |
replicaID | |
synchronize() | |
tableDefs | |
transactions | |
updatable | |
version |
createQueryDef
creates a persistent or temporary queryDef
object. name
property returns the path of the accdb
file. option explicit sub main() dim db as database set db = currentDb() debug.print(db.name) end sub
execute
, openRecordset
allows to execute an arbitrary SQL statement that returns a Recordset.