DAO 3.0/3.5 Collections, Properties, and Methods - Access Database Design and Programming - page 356

Property object

CreateQueryDef [Name], [SQLText] Q ueryDef 3 .0/3.5 Creates a new QueryDef object

[Name], [Table], [ForeignTable],
[Attributes]

CreateRelation 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

PathName As String, Description
As String, [Options]

Makes a new replica based on the
current replicable database

MakeReplica Sub 3.0/3.5

Sub 3.0/3.5 Changes the password of an
existing database
OpenRecordset Name As String, [Type], [Options] Recordset 3.0/3.5 Creates a new Recordset object
PopulatePartial DbPathName As String

bstrOld As String, bstrNew As
String

NewPassword

Sub 3.5 Synchronizes a partial replica

DbPathName As String,
[ExchangeType]

Synchronize Sub 3.0/3.5 Synchronizes the database object

A.5.3 Properties

Property Type Version Description
CollatingOrder L ong 3.0/3.5 Defines the order used for sorting and comparisons
Connect String Information saved from the Connect argument of the OpenDatabase
method
DesignMasterID String 3.0/3.5 Unique identifier for a replica design master
Name S tring 3.0/3.5 The name of this Database object
QueryTimeout Integer 3.0/3.5 Number of seconds before timeout occurs when executing an ODBC
query

RecordsAffected Long 3.0/3.5 Number of records affected by the last Execute method

ReplicaID S tring 3.0/3.5 Unique identifier for a replica

Transactions Boolean 3.0/3.5 Indicates whether the Database object supports transactions

Updatable B oolean 3.0/3.5 Indicates whether the Database object can be modified

Version S tring 3.0/3.5 Version number of the Database object format

A.6 DBEngine Object

A.6.1 Collections

Property Type Version Description
Errors Errors 3.0./3.5 Collection of errors from the most recently failed DAO operation
Properties P roperties 3 .0/3.5 C ollection of Property objects
Workspaces Workspaces 3 .0/3.5 C ollection of open Workspace objects

A.6.2 Methods

Method Parameters Returns V ersion Description

BeginTrans Sub 3.0/3.5 Begins a new transaction

CommitTrans Sub 3 .0 E nds the transaction and