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