DAO Constants

       

DAO provides 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.

Legend:

    Read-only

    Read/write

AllPermissions Property Constants (All Are )

For any Container or Document object:

Constant Description
dbSecReadDef Allows user to read the table definition, including column and index information.
dbSecWriteDef Allows user to modify or delete the table definition, including column and index information.
dbSecRetrieveData Allows user to retrieve data from the Document object.
dbSecInsertData Allows user to add records.
dbSecReplaceData Allows user to modify records.
dbSecDeleteData Allows user to delete records.

The Databases container or any Document object in a Documents collection may include the following:

Constant Description
dbSecDeleteData Allows user to delete records.
dbSecDBAdmin Allows user to replicate the database and change the database password.
dbSecDBCreate Allows user to create new databases. This setting is valid only on the Databases container in the workgroup information file (System.mdw).
dbSecDBExclusive Allows user exclusive access to the database.
dbSecDBOpen Allows user to open the database.

Attributes Property Constants

For any Field object, the Attributes property may include the following:

Constant Description
dbFixedField Fixed field size (default for Numeric fields)
dbVariableField Variable field size (Text fields only)
dbAutoIncrField New record field value incremented to unique Long integer (in a Microsoft Jet workspace, available only on TableDef objects opened from .mdb files)
dbUpdatableField Field is updatable
dbDescending Field sorted in descending order (Microsoft Jet workspaces only)
dbHyperlinkField The field contains hyperlink information (Memo fields in Microsoft Jet workspaces only)
dbSystemField The field is a replication field (on a TableDef object in Microsoft Jet databases only)

For any Relation object, the Attributes property may include the following:

Constant Description
dbRelationUnique One-to-one relationship
dbRelationDontEnforce Relationship not enforced (no referential integrity)
dbRelationInherited Relationship exists in the database containing the two linked tables
dbRelationUpdateCascade Updates cascade
dbRelationDeleteCascade Deletions cascade
dbRelationLeft Microsoft Access only. In Design view, display a LEFT JOIN as the default join type.
dbRelationRight Microsoft Access only. In Design view, display a RIGHT JOIN as the default join type.

For any TableDef object, the Attributes property may include the following:

Constant Description
dbAttachExclusive Opens a linked Microsoft Jet database engine table for exclusive use.
dbAttachSavePWD Saves user ID and password for linked remote table.
dbSystemObject System table
dbHiddenObject Hidden table (for temporary use)
dbAttachedTable Linked non-ODBC database table
dbAttachedODBC Linked ODBC database table

CollatingOrder Property Constants (All Are )

Constant Description
dbSortArabic Arabic collating order
dbSortChineseSimplified Simplified Chinese collating order
dbSortChineseTraditional Traditional Chinese 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
dbSortIcelandic Icelandic collating order
dbSortJapanese Japanese collating order
dbSortKorean Korean 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
dbSortSlovenian Slovenian collating order
dbSortSpanish Spanish collating order
dbSortSwedFin Swedish and Finnish collating order
dbSortThai Thai collating order
dbSortTurkish Turkish collating order
dbSortUndefined Collating order undefined or unknown

DefaultCursorDriver Property (All are )

Constant Description
dbUseDefaultCursor (Default) Uses server-side cursors if the server supports them; otherwise uses the ODBC Cursor Library.
dbUseODBCCursor Always uses the ODBC Cursor Library. This option provides better performance for small result sets, but degrades quickly for larger result sets.
dbUseServerCursor Always uses server-side cursors. For most large operations this option provides better performance, but might cause more network traffic.
dbUseClientBatchCursor Always uses the FoxPro Cursor Library. This option is required for performing batch updates.
dbUseNoCursor Opens all cursors (that is, Recordset objects) as forward-only type, read-only, with a rowset size of 1. Also known as "cursorless queries."

Direction Property Constants (All Are )

Constant Description
dbParamInput (Default) Passes information to the procedure.
dbParamInputOutput Passes information both to and from the procedure.
dbParamOutput Returns information from the procedure as in an output parameter in SQL.
dbParamReturnValue Passes the return value from a procedure.

EditMode Property Constants (All Are )

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

Permissions Property Constants (All are )

For any Container object, the Permissions property may include the following:

Constant Description
dbSecNoAccess Denies user access to the object.
dbSecFullAccess Allows user full access to the object.
dbSecDelete Allows user to delete the object.
dbSecReadSec Allows user to read the object's security-related information.
dbSecWriteSec Allows user to alter access permissions.
dbSecWriteOwner Allows user to change the Owner property setting.

For any database Container, the Permissions property may include any of the following (All are ):

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

For any tables Container, the Permissions property may include any of the following (All are ):

Constant Description
dbSecCreate Allows user to create new tables (valid only with a Container object that represents a table or with the databases Container object in the system database).
dbSecReadDef Allows user to read the table definition, including column and index information.
dbSecWriteDef Allows user to modify or delete the table definition, including column and index information.
dbSecRetrieveData Allows user to retrieve data from the document.
dbSecInsertData Allows user to add records.
dbSecReplaceData Allows user to modify records.
dbSecDeleteData Allows user to delete records.

For any Document object, the Permissions property may include any of the following (All are ):

Constant Description
dbSecCreate Allows user to create new tables (valid only with a Container object that represents a table).
dbSecDBCreate Allows user to create new databases (valid only on the databases Container object in the system database).
dbSecDBOpen Allows user to open the database.
dbSecDBExclusive Allows user exclusive access.
dbSecDelete Allows user to delete the object.
dbSecDeleteData Allows user to delete records.
dbSecFullAccess Allows user full access to the object.
dbSecInsertData Allows user to add records.
dbSecReadDef Allows user to read the table definition, including column and index information.
dbSecReadSec Allows user to read the object's security-related information.
dbSecReplaceData Allows user to modify records.
dbSecRetrieveData Allows user to retrieve data from the document.
dbSecWriteDef Allows user to modify or delete the table definition, including column and index information.
dbSecWriteSec Allows user to alter access permissions.
dbSecWriteOwner Allows user to change the Owner property setting.

Prepare Property Constants (All Are )

Constant Description
dbQPrepare (Default) The statement is prepared (that is, the ODBC SQLPrepare API is called).
dbQUnprepare The statement is not prepared (that is, the ODBC SQLExecDirect API is called).

RecordStatus Property Constants (All Are )

Constant Description
dbDBDeleted The record has been deleted locally and in the database.
dbDeleted The record has been deleted, but not yet deleted in the database.
dbRecordModified The record has been modified and not updated in the database.
dbRecordNew The record has been inserted with the AddNew method, but not yet inserted into the database.
dbRecordUnmodified (Default) The record has not been modified or has been updated successfully.

Type Property Constants

For any Field, Parameter, or Property object, the Type property may include any of the follwing (All are ):

Constant Description
dbBigInt Big Integer data (ODBCDirect only)
dbBinary Binary data
dbBoolean Boolean (True/False) data
dbByte Byte (8-bit) data
dbChar Character data (ODBCDirect only)
dbCurrency Currency data
dbDate Date value data
dbDecimal Decimal data (ODBCDirect only)
dbDouble Double-precision floating-point data
dbFloat Floating-point data (ODBCDirect only)
dbGUID GUID data
dbInteger Integer data
dbLong Long Integer data
dbLongBinary Binary data (bitmap)
dbMemo Memo data (extended text)
dbNumeric Numeric data (ODBCDirect only)
dbSingle Single-precision floating-point data
dbText Text data (variable width)
dbTime Data in time format (ODBCDirect only)
dbTimeStamp Data in time and date format (ODBCDirect only)
dbVarBinary Variable Binary data (ODBCDirect only)

For any QueryDef object, the Type property may include any of the following (All are ):

Constant Description
dbQAction Action query
dbQAppend Append query
dbQCompound Compound query (ODBCDirect workspaces only)
dbQCrosstab Crosstab query
dbQDDL Data-definition language (DDL) query
dbQDelete Delete query
dbQMakeTable Make-table query
dbQProcedure SQL procedure that executes a stored procedure (ODBCDirect workspaces only)
dbQSelect Select query
dbQSetOperation Set operation query
dbQSPTBulk Bulk operation query
dbQSQLPassThrough SQL pass-through query
dbQUpdate Update query

For any Recordset object, the Type property may include any of the following (All are ):

Constants Description
dbOpenDynamic Opens a dynaset-type Recordset (ODBCDirect workspaces only)
dbOpenDynaset Opens a dynaset-type Recordset
dbOpenForwardOnly Opens a forward-only type Recordset
dbOpenSnapshot Opens a snapshot-type Recordset
dbOpenTable Opens a table-type Recordset (Microsoft Jet workspaces only)

UpdateOptions Property Constants (All Are )

Constant Description
dbCriteriaKey (Default) Uses just the key column(s) in the where clause.
dbCriteriaModValues Uses the key column(s) and all updated columns in the where clause.
dbCriteriaAllCols Uses the key column(s) and all the columns in the where clause.
dbCriteriaTimeStamp Uses just the timestamp column if available (will generate a run-time error if no timestamp column is in the result set).
dbCriteriaDeleteInsert Uses a pair of DELETE and INSERT statements for each modified row.
dbCriteriaUpdate (Default) Uses an UPDATE statement for each modified row.

CompactDatabase, CreateDatabase Methods Locale Argument Constants (All Are )

Constant Description
dbLangGeneral English, German, French, Portuguese, Italian, and Modern Spanish
dbLangArabic Arabic
dbLangChineseSimplified Simplified Chinese
dbLangChineseTraditional Traditional Chinese
dbLangCyrillic Russian
dbLangCzech Czech
dbLangDutch Dutch
dbLangGreek Greek
dbLangHebrew Hebrew
dbLangHungarian Hungarian
dbLangIcelandic Icelandic
dbLangJapanese Japanese
dbLangKorean Korean
dbLangNordic Nordic
dbLangNorwDan Norwegian and Danish
dbLangPolish Polish
dbLangSlovenian Slovenian
dbLangSpanish Spanish
dbLangSwedFin Swedish and Finnish
dbLangThai Thai
dbLangTurkish Turkish

CompactDatabase Method Options Argument Constants (All Are )

Constant Description
dbDecrypt Decrypts database while compacting
dbEncrypt Encrypts 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 Options Argument Constants (All Are )

Constant Description
dbEncrypt Encrypts 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

CreateWorkspace Method Type Argument Constants

For any Workspace object Type property and DBEngine object DefaultType property, use any of the following: (All Are )

Constant Description
dbUseODBC The next workspace created will use ODBCDirect.
dbUseJet The next workspace created will use the Microsoft Jet database engine.

Execute Method Options Argument Constants (All Are )

Constant Description
dbDenyWrite Denies write permission to other users (Microsoft Jet workspaces only).
dbInconsistent Allows inconsistent updates (Microsoft Jet workspaces only).
dbConsistent Allows consistent updates (Microsoft Jet workspaces only).
dbSQLPassThrough An SQL pass-through. Causes the SQL statement to be passed to an ODBC database for processing (Microsoft Jet workspaces only).
dbFailOnError Rolls back updates if an error occurs (Microsoft Jet workspaces only).
dbSeeChanges Generates a run-time error if another user is changing data you are editing (Microsoft Jet workspaces only).
dbRunAsync Executes the query asynchronously (ODBCDirect workspaces only).
dbExecDirect Executes the query without first calling the SQLPrepare ODBC function (ODBCDirect workspaces only).

Idle Method Optional Argument Constant (This Is )

Constant Description
dbRefreshCache Forces any pending writes to disk, and refreshes memory from current disk files.

MakeReplica Method Optional Argument Constants (All are )

Constant Description
dbRepMakePartial Creates a partial replica.
dbRepMakeReadOnly Makes replicable elements of new database read-only.

OpenConnection and OpenDatabase Methods Option Argument Constants (All Are )

Constant Description
dbDriverNoPrompt The driver manager uses the connection string provided in connect. If sufficient information is not provided, a trappable error is returned.
dbDriverPrompt The driver manager displays the ODBC Data Sources dialog box. The connection string used to establish the connection is constructed from the data source name (DSN) selected and completed by the user via the dialog boxes.
dbDriverComplete If the connection string provided includes the DSN keyword, the driver manager uses the string as provided in connect, otherwise it behaves as it does when dbDriverPrompt is specified.
dbDriverCompleteRequired (Default) Behaves like dbDriverComplete except the driver disables the controls for any information not required to complete the connection.

OpenRecordset Method Type Argument Constants (All Are )

Constant Description
dbOpenDynamic Opens a dynamic-type Recordset (ODBCDirect workspaces only)
dbOpenDynaset Opens a dynaset-type Recordset
dbOpenForwardOnly Opens a forward-only type Recordset
dbOpenSnapshot Opens a snapshot-type Recordset
dbOpenTable Opens a table-type Recordset (Microsoft Jet workspaces only)

OpenRecordset Method LockEdits Argument Constants (All Are )

Constant Description
dbPessimistic Pessimistic concurrency. Cursor uses the lowest level of locking sufficient to ensure the record can be updated.
dbReadOnly Cursor is read-only. No updates are allowed.
dbOptimistic Optimistic concurrency based on record ID. Cursor compares record ID in old and new records to determine if changes have been made since the record was last accessed.
dbOptimisticValue Optimistic concurrency based on record values. Cursor compares data values in old and new records to determine if changes have been made since the record was last accessed (ODBCDirect workspaces only).
dbOptimisticBatch Enables batch optimistic updates (ODBCDirect workspaces only).

OpenRecordset Method Options Argument Constants (All Are )

Constant Description
dbDenyWrite Prevents other users from changing Recordset records (Microsoft Jet workspaces only).
dbDenyRead Prevents other users from reading Recordset records (table-type in Microsoft Jet workspaces only).
dbReadOnly Opens the Recordset as read-only (Microsoft Jet workspaces only).
dbAppendOnly Allows user to add new records to the dynaset, but prevents user from reading existing records (dynaset-type in Microsoft Jet workspaces only).
dbInconsistent Applies updates to all dynaset fields, even if other records are affected (dynaset- and snapshot-type in Microsoft Jet workspaces only).
dbConsistent Applies updates only to those fields that will not affect other records in the dynaset (dynaset- and snapshot-type in Microsoft Jet workspaces only).
dbSQLPassThrough Sends an SQL statement to an ODBC database (snapshot-type in Microsoft Jet workspaces only).
dbForwardOnly Creates a forward-only scrolling snapshot-type Recordset (snapshot-type in Microsoft Jet workspaces only).
dbSeeChanges Generates a run-time error if another user is changing data you are editing (dynaset-type in Microsoft Jet workspaces only).
dbRunAsync Executes the query asynchronously (ODBCDirect workspaces only).
dbExecDirect Executes the query without first calling the SQLPrepare ODBC function (ODBCDirect workspaces only).

SetOption Method Parameter Constants (All Are )

Constant Description
dbPageTimeout The PageTimeout key
dbSharedAsyncDelay The SharedAsyncDelay key
dbExclusiveAsyncDelay The ExclusiveAsyncDelay key
dbLockRetry The LockRetry key
dbUserCommitSync The UserCommitSync key
dbImplicitCommitSync The ImplicitCommitSync key
dbMaxBufferSize The MaxBufferSize key
dbMaxLocksPerFile The MaxLocksPerFile key
dbLockDelay The LockDelay key
dbRecycleLVs The RecycleLVs key
dbFlushTransactionTimeout The FlushTransactionTimeout key

Synchronize Method Exchange Argument Constants (All Are )

Constant Description
dbRepExportChanges Sends changes from current database to target database.
dbRepImportChanges Receives changes from target database.
dbRepImpExpChanges Sends and receives data in a bidirectional exchange.
dbRepSyncInternet Exchanges data between files connected via an Internet pathway.

Update Method Type Argument Constants (All Are )

Constant Description
dbUpdateRegular (Default) Pending changes aren't cached and are written to disk immediately.
dbUpdateBatch All pending changes in the update cache are written to disk.
dbUpdateCurrentRecord Only the current record's pending changes are written to disk.

CancelUpdate Method Type Argument Constants (All Are )

Constant Description
dbUpdateRegular (Default) Pending changes aren't cached and are written to disk immediately.
dbUpdateBatch All pending changes in the update cache are written to disk.