Data Access Constants

Description

You can use the Object Browser to view a list of built-in constants. From the View menu, choose Object Browser, select the appropriate library, and then select the Constants object. Scroll the list in the Methods/Properties box to see the complete list of constants.

The data access objects provide built-in constants that you can use with methods or properties. These constants all begin with the letters db and are documented with the method or property to which they apply.

Attributes Property Constants

Field.Attributes Property

Constant	Description

dbFixedField	Read/write. Field size fixed (default for Numeric fields).
dbVariableField	Read/write. Field size variable (Text fields only).
dbAutoIncrField	Read/write. New record field value incremented to unique Long integer (Counter type).
dbUpdatableField	Read-only. Field is updatable.
dbDescending	Read/write. Field sorted in descending order.
dbSystemField	Read-only. The field is a replication field (on a TableDef object).

Relation.Attributes Property

Constant	Description

dbRelationUnique	Read/write. One-to-one relationship.
dbRelationDontEnforce	Read/writeRelationship not enforced (no referential integrity).
dbRelationInherited	Read-only. Relationship exists in the database containing the two attached tables.
dbRelationUpdateCascade	Read/write. Updates cascade.
dbRelationDeleteCascade	Read/write. Deletions cascade.

TableDef.Attributes Property

Constant	Description

dbAttachExclusive	Read/write. Attached Microsoft Jet database engine table opened for exclusive use.
dbAttachSavePWD	Read/write. Save user ID and password for attached remote table.
dbSystemObject	Read-only. System table.
dbHiddenObject	Read/write. Hidden table (for temporary use).
dbAttachedTable	Read-only. Attached non-ODBC database table.
dbAttachedODBC	Read-only. Attached ODBC database table.

CollatingOrder Property Constants

All of the following constants are read/write.

Constant	Description

dbSortArabic	Arabic collating order.
dbSortCyrillic	Russian collating order.
dbSortCzech	Czech collating order.
dbSortDutch	Dutch collating order.
dbSortGeneral	English, German, French, and Portuguese collating order.
dbSortGreek	Greek collating order.
dbSortHebrew	Hebrew collating order.
dbSortHungarian	Hungarian collating order.

Constant	Description

dbSortIcelandic	Icelandic collating order.
dbSortJapanese	Japanese collating order.
dbSortNeutral	Neutral collating order.
dbSortNorw	Norwegian and Danish collating order.
dbSortPDXIntl	Paradox international collating order.
dbSortPDXNor	Paradox Norwegian and Danish collating order.
dbSortPDXSwe	Paradox Swedish and Finnish collating order.
dbSortPolish	Polish collating order.
dbSortSpanish	Spanish collating order.
dbSortSwedFin	Swedish and Finnish collating order.
dbSortTurkish	Turkish collating order.
dbSortUndefined	Collating order undefined or unknown.

EditMode Property Constants

All of the following constants are read-only.

Constant	Description

dbEditNone	No editing operation in effect.
dbEditInProgress	Edit method invoked.
dbEditAdd	AddNew method invoked.

Permissions Property Constants

Container.Permissions Property

All of the following constants are read/write.

Constant	Description

dbSecNoAccess	No access to the object.
dbSecFullAccess	Has full access to the object.
dbSecDelete	Can delete the object.
dbSecReadSec	Can read the object's security-related information.
dbSecWriteSec	Can alter access permissions.
dbSecWriteOwner	Can change the Owner property setting.

Databases Container.Permissions Property

All of the following constants are read/write.

Constant	Description

dbSecDBAdmin	Gives user permission to make a database replicable and change the database password.
dbSecDBCreate	Can create new databases (valid only on the databases Container object in the system database).
dbSecDBOpen	Can open the database.
dbSecDBExclusive	Has exclusive access.

Tables Container.Permissions Property

All of the following constants are read/write.

Constant	Description

dbSecCreate	Create new tables (valid only with a Container object that represents a table or with the databases Container object in the system database).
dbSecReadDef	Read the table definition, including column and index information.
dbSecWriteDef	Modify or delete table definition, including column and index information.
dbSecRetrieveData	Retrieve data from the document.
dbSecInsertData	Add records.
dbSecReplaceData	Modify records.
dbSecDeleteData	Delete records.

Document.Permissions Property

All of the following constants are read/write.

Constant	Description

dbSecCreate	Create new tables (valid only with a Container object that represents a table).
dbSecDBCreate	Can create new databases (valid only on the databases Container object in the system database).
dbSecDelete	Can delete the object.

Constant	Description

dbSecDBOpen	Can open the database.
dbSecDBExclusive	Has exclusive access.
dbSecDelete	Can delete the object.
dbSecDeleteData	Delete records.
dbSecFullAccess	Has full access to the object.
dbSecInsertData	No access to the object.
dbSecReadDef	Read the table definition, including column and index information.
dbSecReadSec	Can read the object's security-related information.
dbSecReplaceData	Modify records.
dbSecRetrieveData	Retrieve data from the document.
dbSecWriteDef	Modify or delete table definition, including column and index information.
dbSecWriteSec	Can alter access permissions.
dbSecWriteOwner	Can change the Owner property setting.

Type Property Constants

Field.Type Property, Parameter.Type Property, Property.Type Property

All of the following constants are read/write.

Constant	Description

dbBoolean	Boolean (True/False) data.
dbByte	Byte (8-bit) data.
dbInteger	Integer data.
dbLong	Long Integer data.
dbCurrency	Currency data.
dbSingle	Single-precision floating-point data.
dbDouble	Double-precision floating-point data.
dbDate	Date value data.
dbText	Text data (variable width).
dbLongBinary	Binary data (bitmap).
dbMemo	Memo data (extended text).
dbGUID	GUID data.

QueryDef.Type Property

All of the following constants are read-only.

Constant	Description

dbQSelect	SELECT query.
dbQAction	Action query.
dbQCrosstab	Crosstab query.
dbQDelete	DELETE query.
dbQUpdate	UPDATE query.
dbQAppend	APPEND query.
dbQMakeTable	Make-table query.
dbQDDL	Data definition language (DDL) query.
dbQSQLPassThrough	SQL pass-through query.
dbQSetOperation	Set operation query.
dbQSPTBulk	Bulk operation query.

Recordset.Type Property

All of the following constants are read-only.

Constant	Description

dbOpenTable	Open table-type Recordset.
dbOpenDynaset	Open dynaset-type Recordset.
dbOpenSnapshot	Open snapshot-type Recordset.

CompactDatabase, CreateDatabase Methods

The following constants are for the locale argument. All are read/write.

Constant	Description

dbLangArabic	Arabic collating order.
dbLangCyrillic	Russian collating order.
dbLangCzech	Czech collating order.
dbLangDutch	Dutch collating order.
dbLangGeneral	English, German, French, Portuguese, Italian, and Modern Spanish collating order.
dbLangGreek	Greek collating order.
dbLangHebrew	Hebrew collating order.
dbLangHungarian	Hungarian collating order.
dbLangIcelandic	Icelandic collating order.
dbLangJapanese	Japanese collating order.

Constant	Description

dbLangNeutral	Neutral collating order.
dbLangNordic	Nordic collating order.
dbLangNorwdan	Norwegian and Danish collating order.
dbLangPolish	Polish collating order.
dbLangSpanish	Spanish collating order.
dbLangSwedfin	Swedish and Finnish collating order.
dbLangTurkish	Turkish collating order.

CompactDatabase Method

The following constants are for the options argument. All are read/write.

Constant	Description

dbDecrypt	Decrypt database while compacting.
dbEncrypt	Encrypt database.
dbVersion10	Microsoft Jet database engine version 1.0.
dbVersion11	Microsoft Jet database engine version 1.1.
dbVersion20	Microsoft Jet database engine version 2.0.
dbVersion30	Microsoft Jet database engine version 3.0.

CreateDatabase Method

The following constants are for the options argument. All are read/write.

Constant	Description

dbEncrypt	Encrypt database.
dbVersion10	Microsoft Jet database engine version 1.0.
dbVersion11	Microsoft Jet database engine version 1.1.
dbVersion20	Microsoft Jet database engine version 2.0.
dbVersion30	Microsoft Jet database engine version 3.0.

Execute Method

The following constants are for the options argument. All are read/write.

Constant	Description

dbDenyWrite	Deny write permission to other users.
dbInconsistent	Inconsistent updates.
dbConsistent	Consistent updates.
dbSQLPassThrough	SQL pass-through. Causes the SQL statement to be passed to an ODBC database for processing.
dbFailOnError	Rolls back updates if an error occurs.
dbSeeChanges	Generates a run-time error if another user is changing data you are editing.

Idle Method

The following constant is for the optional argument.

Constant	Description

dbFreeLocks	Read/write. Delay processing until all read locks are released.

OpenRecordset Method

The following constants are for the type argument. All are read/write.

Constants	Description

dbOpenTable	Open table-type Recordset.
dbOpenDynaset	Open dynaset-type Recordset.
dbOpenSnapshot	Open snapshot-type Recordset.

The following constants are for the options argument. All are read/write.

Constant	Description

dbDenyWrite	Other users can't change Recordset records.
dbDenyRead	Other users can't read Recordset records.
dbReadOnly	Open the Recordset as read-only.
dbAppendOnly	You can add new records to the dynaset, but you can't read existing records.
dbInconsistent	Updates apply to all dynaset fields, even if other records are affected.
dbConsistent	Updates apply only to those fields that will not affect other records in the dynaset.
dbSQLPassThrough	Sends an SQL statement to an ODBC database.
dbForwardOnly	Create a forward-only scrolling snapshot-type Recordset.

MakeReplica Method

The following constant is for the optional argument.

Constant	Description

dbRepMakeReadOnly	Read/Write. Replicable elements of new database are read-only.

Synchronize Method

The following constants are for the exchange argument.

Constant	Description

dbRepExportChanges	Read/Write. Send changes from current database to target database.
dbRepImportChanges	Read/Write. Receive changes from target database.