Beginning Access 1002002 Vba [Electronic resources]

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.

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.