Database

team lib

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.

 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net