Access Database Design and Programming, Second Edition

Database Object

Collections

Property	Type	Version	Description
Connection	Connection	3.5	An open ODBCDirect connection
Containers	Containers	3.0/3.5	Collection of Container objects in the Database object
QueryDefs	QueryDefs	3.0/3.5	Collection of QueryDef objects in the Database object
Recordsets	Recordsets	3.0/3.5	Collection of Recordset objects open in Database object
Relations	Relations	3.0/3.5	Collection of Relation objects in the Database object
TableDefs	TableDefs	3.0/3.5	Collection of TableDef objects in the Database object

Methods

Method	Parameters	Returns	Version	Description
Close		Sub	3.0/3.5	Closes the Database object and everything it contains
CreateProperty	[Name], [Type], [Value], [DDL]	Property	3.0/3.5	Creates a new user-defined Property object
CreateQueryDef	[Name], [SQLText]	QueryDef	3.0/3.5	Creates a new QueryDef object
CreateRelation	[Name], [Table], [ForeignTable], [Attributes]	Relation	3.0/3.5	Creates a new Relation object
CreateTableDef	[Name], [Attributes], [SourceTableName], [Connect]	TableDef	3.0/3.5	Creates a new TableDef object
Execute	Query As String, [Options]	Sub	3.0/3.5	Executes a query
MakeReplica	PathName As String, Description As String, [Options]	Sub	3.0/3.5	Makes a new replica based on the current replicable database
NewPassword	bstrOld As String, bstrNew As String	Sub	3.0/3.5	Changes the password of an existing database
OpenRecordset	Name As String, [Type], [Options]	Recordset ...