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.