Database

Methods

Name	Returns	Description
Close		Closes the database object.
CreateProperty	Property	Creates a new user -defined Property.
CreateQueryDef	QueryDef	Creates a new QueryDef object.
CreateRelation	Relation	Creates a new Relation object.
CreateTableDef	TableDef	Creates a new TableDef object.
Execute		Runs a SQL statement or an action query.
MakeReplica		Creates a new replica from an existing database replica.
NewPassword		Changes the password for a user.
OpenRecordset	Recordset	Opens a recordset.
PopulatePartial		Synchronizes the partial replica database with the full replica database, in a specific manner.
Synchronize		Fully synchronizes two replica databases.

Properties

Name	Returns	Description
CollatingOrder	Long	Specifies the sort order. Returns one of the dbSort constants. Read-only.
Connect	String	Defines the source of an open connection.
Connection	Connection	Identifies the Connection object corresponding to the open database. Read-only.
Containers	Containers	Collection of Container objects defined in a Database object. Read-only.
DesignMasterID	String	Specifies the unique GUID that identifies the Design Master in a set of replicated databases.
Name	String	Identifies the database name. Read-only.
Properties	Properties	Collection of Property objects. Read-only.
QueryDefs	QueryDefs	Collection of QueryDef objects in a Database object. Read-only.
QueryTimeout	Integer	Indicates how long, in seconds, to wait before an error occurs whilst executing a query. The default value is 60.
RecordsAffected	Long	Contains the number of records affected by the last Execute method. Read-only.
Recordsets	Recordsets	Collection of Recordset objects open in a Database object. Read-only.
Relations	Relations	Collection of Relation objects in a Database object. Read-only.
ReplicaID	String	Specifies the unique GUID that identifies the replica database in a set of replicated databases. Read-only.
TableDefs	TableDefs	Collection of TableDef objects in a Database object. Read-only.
Transactions	Boolean	Indicates whether or not the database supports transactions. Read-only.
Updatable	Boolean	Indicates whether or not data in the database can be changed. Read-only.
Version	String	Returns the version of the Jet database. Read-only.