Constants

CommitTransOptionsEnum

Name	Value	Description
dbForceOSFlush	1	When used with CommitTrans forces all updates to be immediately flushed to the disk.

DatabaseTypeEnum

Name	Value	Description
dbDecrypt	4	The database is not encrypted.
dbEncrypt	2	The database is encrypted.
dbVersion10	1	The database is a version 1.0 database.
dbVersion11	8	The database is a version 1.1 database.
dbVersion20	16	The database is a version 2.0 database.
dbVersion30	32	The database is a version 3.0 database.
dbVersion40	64	The database is a version 4.0 database.

DataTypeEnum

Name	Value	Description
dbBigInt	16	A signed integer.
dbBinary	9	A binary value, with a maximum length of 255 bytes.
dbBoolean	1	A Boolean value.
dbByte	2	A single byte value, for integer values from 0 to 255.
dbChar	18	A String value, for fixed length strings.
dbCurrency	5	A currency value. A signed integer with 4 digits to the right of the decimal point.
dbDate	8	A Date value, holding dates between December 30 1899 and December 30 9999 inclusive, and times between 00:00:00 and 23:59:59.
dbDecimal	20	A signed, exact numeric value.
dbDouble	7	A double precision floating point number.
dbFloat	21	A signed, approximate numeric value.
dbGUID	15	A Globally Unique Identifier.
dbInteger	3	An Integer, for values between -32,768 and 32,767.
dbLong	4	A Long Integer , for values between -2,147,483,648 and 2,147,483,647.
dbLongBinary	11	A Long Binary object, such as an OLE Object.
dbMemo	12	Text data, up to 1.2Gb in length.
dbNumeric	19	A singed, exact numeric value.
dbSingle	6	A single precision floating point number.
dbText	10	Text data for values up to 255 characters .
dbTime	22	A time value.
dbTimeStamp	23	A unique time stamp.
dbVarBinary	17	Variable length binary data, up to 255 bytes in length.

DriverPromptEnum

Name	Value	Description
dbDriverComplete		Only prompt if not enough information was supplied.
dbDriverCompleteRequired	3	Only prompt if not enough information was supplied, but disable any options not directly applicable to the connection.
dbDriverNoPrompt	1	Default. Never prompt for connection information.
dbDriverPrompt	2	Always prompt for connection information.

EditModeEnum

Name	Value	Description
dbEditAdd	2	Indicates that the AddNew method has been invoked and the current record in the buffer is a new record that hasn't been saved to the database.
dbEditInProgress	1	Indicates that data in the current record has been modified but not saved.
dbEditNone		Indicates that no editing is in progress.

FieldAttributeEnum

Name	Value	Description
dbAutoIncrField	16	The field is an auto-incrementing field, such as an AutoNumber .
dbDescending	1	The field is stored in descending order.
dbFixedField	1	The field is a fixed size .
dbHyperlinkField	32768	The field is a hyperlink field.
dbSystemField	8192	The field holds replication information.
dbUpdatableField	32	The field is updateable.
dbVariableField	2	The field size is variable.

IdleEnum

Name	Value	Description
dbFreeLocks	1	Frees any read locks.
dbRefreshCache	8	Refreshes the memory with the most current data from the database.

LockTypeEnum

Name	Value	Description
dbOptimistic	3	Optimistic locking, record-by-record. The provider locks records when Update is called.
dbOptimisticBatch	5	Optimistic batch updates, allowing more than one update to take place before the data source is updated.
dbPessimistic	2	Pessimistic locking, record-by-record. The provider locks the record immediately upon editing.

ParameterDirectionEnum

Name	Value	Description
dbParamInput	1	Indicates an input parameter.
dbParamInputOutput	3	Indicates both an input and output parameter.
dbParamOutput	2	Indicates an output parameter.
dbParamReturnValue	4	Indicates a return value.

PermissionEnum

Name	Value	Description
dbSecCreate	1	The user can create new documents.
dbSecDBAdmin	8	The user can replicate a database and change the database password.
dbSecDBCreate	1	The user can create new databases.
dbSecDBExclusive	4	The user has exclusive access to the database.
dbSecDBOpen	2	The user can open the database.
dbSecDelete	65536	The user can delete the object.
dbSecDeleteData	128	The user can delete records.
dbSecFullAccess	1048575	The user has full access to the objects.
dbSecInsertData	32	The user can add records.
dbSecNoAccess		The user has no access to the object.
dbSecReadDef	4	The user can read the table definition.
dbSecReadSec	131072	The user can read the object's security details.
dbSecReplaceData	64	The user can modify records.
dbSecRetrieveData	20	The user can retrieve data from the object.
dbSecWriteDef	65548	The user can update the table definition.
dbSecWriteOwner	524288	The user can change the Owner property.
dbSecWriteSec	262144	The user can update the object's security details.

QueryDefTypeEnum

Name	Value	Description
dbQAction	240	The query is an action query.
dbQAppend	64	The query is an Append query.
dbQCompound	160	The query contains an action query and a select query.
dbQCrosstab	16	The query is a Crosstab query.
dbQDDL	96	The query is a Data Definition query.
dbQDelete	32	The query is a Delete query.
dbQMakeTable	80	The query is a Make Table query.
dbQProcedure	224	The query executes a stored procedure ( ODBCDirect only)
dbQSelect		The query is a Select query.
dbQSetOperation	128	The query is a Union Query.
dbQSPTBulk	144	The query is an ODBC pass through query that doesn't return records. Used in conjunction with dbQSQLPassThrough .
dbQSQLPassThrough	112	The query is an ODBC pass through query.
dbQUpdate	48	The query is an Update query.

RecordsetOptionEnum

Name	Value	Description
dbAppendOnly	8	Do not allow changes to existing records, but allow new records to be added.
dbConsistent	32	Allow only consistent updates to the recordset. Most useful for multi-table joins.
dbDenyRead	2	Prevent other users from reading data in the table.
dbDenyWrite	1	Prevent other users from modifying or adding records.
dbExecDirect	2048	For ODBCDirect only, allows the query to be sent directly to the server without being prepared.
dbFailOnError	128	Terminate the opening of the recordset if an error occurs.
dbForwardOnly	256	Creates a forward-only recordset.
dbInconsistent	16	Allow inconsistent updates to the recordset. Most useful for multi-table joins.
dbReadOnly	4	Creates a read-only recordset.
dbRunAsync	1024	For ODBCDirect , opens the recordset asynchronously.
dbSeeChanges	512	Allows errors to be generated when an attempt is made to edit a record that is already being edited by another user.
dbSQLPassThrough	64	Passes the SQL directly to the ODBC data source.

RecordsetTypeEnum

Name	Value	Description
dbOpenDynamic	16	A dynamic recordset (dynamic cursor).
dbOpenDynaset	2	A dynaset recordset (keyset cursor).
dbOpenForwardOnly	8	A forward-only recordset.
dbOpenSnapshot	4	A snapshot recordset (static cursor)
dbOpenTable	1	A table-type recordset.

RecordStatusEnum

Name	Value	Description
dbRecordDBDeleted	4	The record has been deleted both in the recordset and in the database.
dbRecordDeleted	3	The record has been deleted from the recordset, but has yet to be deleted from the database.
dbRecordModified	1	The record has been modified in the recordset, but not in the database.
dbRecordNew	2	The record has been added into the recordset, but not yet added to the database.
dbRecordUnmodified		The record has not been modified, or has been successfully modified.

RelationAttributeEnum

Name	Value	Description
dbRelationDeleteCascade	4096	Deletions will cascade to related tables.
dbRelationDontEnforce	2	No referential integrity is in place, and relationships are not enforced.
dbRelationInherited	4	The relationship is between two tables that exist in another database.
dbRelationLeft	16777216	The relationship is a left outer join.
dbRelationRight	33554432	The relationship is a right outer join.
dbRelationUnique	1	The relationship is a one to one.
dbRelationUpdateCascade	256	Updates will cascade to related tables.

ReplicaTypeEnum

Name	Value	Description
dbRepMakePartial	1	Create a partial replica.
dbRepMakeReadOnly	2	Create read-only replica, prohibiting changes to replicable objects.

SetOptionEnum

Name	Value	Description
dbExclusiveAsyncDelay	60	Sets the ExclusiveAsyncDelay registry key.
dbFlushTransactionTimeout	66	Sets the FlushTransactionTimeout registry key.
dbImplicitCommitSync	59	Sets the ImplicitCommitSync registry key.
dbLockDelay	63	Sets the LockDelay registry key.
dbLockRetry	57	Sets the LockRetry registry key.
dbMaxBufferSize	8	Sets the MaxBufferSize registry key.
dbMaxLocksPerFile	62	Sets the MaxLocksPerFile registry key.
dbPageTimeout	6	Sets the PageTimeout registry key.
dbRecycleLVs	65	Sets the RecycleLVs registry key.
dbSharedAsyncDelay	61	Sets the SharedAsyncDelay registry key.
dbUserCommitSync	58	Sets the UserCommitSync registry key.

SynchronizeTypeEnum

Name	Value	Description
dbRepExportChanges	1	Export database changes.
dbRepImpExpChanges	4	Import and export database changes.
dbRepImportChanges	2	Import database changes.
dbRepSyncInternet	16	Synchronize changes over the Internet.

TableDefAttributeEnum

Name	Value	Description
dbAttachedODBC	536870912	The table is a linked table from an ODBC data source.
dbAttachedTable	1073741824	The table is a linked table from a non- ODBC data source.
dbAttachExclusive	65536	The table is a linked table, for exclusive use only.
dbAttachSavePWD	131072	The table is a linked table, and the user and password details are saved with the connection.
dbHiddenObject	1	The table is a hidden table.
dbSystemObject	-2147483646	The table is a system table.

UpdateCriteriaEnum

Name	Value	Description
dbCriteriaAllCols	4	Use all columns in the WHERE clause to identify the record being updated.
dbCriteriaDeleteInsert	16	A set of DELETE and INSERT statements are created to modify the row.
dbCriteriaKey	1	Use just the key columns in the WHERE clause to identify the record being updated.
dbCriteriaModValues	2	Use the key columns and changed columns in the WHERE clause to identify the record being updated.
dbCriteriaTimestamp	8	Only use a timestamp field, if available.
dbCriteriaUpdate	32	Use an UPDATE statement for the changed row.

UpdateTypeEnum

Name	Value	Description
dbUpdateBatch	4	Write all pending changes to the disk.
dbUpdateCurrentRecord	2	Only write the pending changes for the current record to the disk.
dbUpdateRegular	1	Write the pending changes immediately to the disk, and don't cache them. This is the default.

WorkspaceTypeEnum

Name	Value	Description
dbUseJet	2	The Workspace is connected to a Jet database.
dbUseODBC	1	The Workspace is connected to an ODBC data source.