Database Members (DAO)

Article
10/12/2015

A Database object represents an open database.

Methods

Name	Description
Close	Closes an open Database.
CreateProperty	Creates a new user-defined Property object (Microsoft Access workspaces only). .
CreateQueryDef	Creates a new QueryDef object.
CreateRelation	Creates a new Relation object (Microsoft Access workspaces only). .
CreateTableDef	Creates a new TableDef object (Microsoft Access workspaces only). .
Execute	Runs an action query or executes an SQL statement on the specified object.
MakeReplica	Makes a new replica from another database replica (Microsoft Access workspaces only).
NewPassword	Changes the password of an existing Microsoft Access database engine database (Microsoft Access workspaces only).
OpenRecordset	Creates a new Recordset object and appends it to the Recordsets collection.
PopulatePartial	Synchronizes any changes in a partial replica with the full replica, clears all records in the partial replica, and then repopulates the partial replica based on the current replica filters. (Microsoft Access database engine databases only.).
Synchronize	Synchronizes two replicas. (Microsoft Access workspaces only).

Properties

Name	Description
CollatingOrder	Returns a value that specifies the sequence of the sort order in text for string comparison or sorting (Microsoft Access workspaces only). Read-only Long.
Connect	Sets or returns a value that provides information about the source an open database. Read/write String.
Connection	Note ODBCDirect workspaces are not supported in Microsoft Access 2010. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Returns the Connection object that corresponds to the database (ODBCDirect workspaces only).
Containers	Returns a Containers collection that represents all of the Container objects in the specifed database. Read-only.
DesignMasterID	Sets or returns a 16-byte value that uniquely identifies the Design Master in a replica set (Microsoft Access workspaces only).
Name	Returns the name of the specified object. Read-only String.
Properties	Returns the Properties collection of the specified object. Read-only.
QueryDefs	Returns a QueryDefs collection that contains all of the QueryDef objects of the specified database. Read-only.
QueryTimeout	Sets or returns a value that specifies the number of seconds to wait before a timeout error occurs when a query is executed on an ODBC data source.
RecordsAffected	Returns the number of records affected by the most recently invoked Execute method.
Recordsets	Returns a Recordsets collection that contains all of the open recordsets in the for the specified database. Read-only.
Relations	Returns a Relations collection that contains all of the stored Relation objects for the specified database. Read-only.
ReplicaID	Returns a 16-byte value that uniquely identifies a database replica (Microsoft Access workspaces only).
TableDefs	Returns a TableDefs collection that contains all of the TableDef objects stored in the specified database. Read-only.
Transactions	Returns a value that indicates whether an object supports transactions. Read-only Boolean.
Updatable	Returns a value that indicates whether you can change a DAO object. Read-only Boolean.
Version	In a Microsoft Access workspace, returns the vesion of the Microsoft Jet or Microsoft Access database engine that created the database. Read-only String.