Jet 提供者还支持多个提供者特有的 Recordset 和 Command 属性。这些属性可以通过 Recordset 或 Command 对象的 Properties 集合进行访问和设置。表中列出了 ADO 属性名称，括号内为相应的 OLE DB 属性名。

学63网U7页ggb网(http://www.xwangye.com)

属性名称	说明
Jet OLEDB:Bulk Transactions (DBPROP_JETOLEDB_BULKNOTRANSACTIONS)	指示是否处理 SQL 大量操作。由于资源延迟，处理大量操作时可能会失败。
Jet OLEDB:Enable Fat Cursors (DBPROP_JETOLEDB_ENABLEFATCURSOR)	指示预置远程行源的记录集时 Jet 是否应该缓存多行。
Jet OLEDB:Fat Cursor Cache Size (DBPROP_JETOLEDB_FATCURSORMAXROWS)	指示使用远程数据存储行进行缓存时缓存的行数。除非 Jet OLEDB:Enable Fat Cursors 为 Ture，否则将忽略此值。
Jet OLEDB:Inconsistent (DBPROP_JETOLEDB_INCONSISTENT)	指示查询结果是否允许不一致的更新。
Jet OLEDB:Locking Granularity (DBPROP_JETOLEDB_LOCKGRANULARITY)	指示表是否使用行级锁定打开。
Jet OLEDB:ODBC Pass-Through Statement (DBPROP_JETOLEDB_ODBCPASSTHROUGH)	指示 Jet 应该把 Command 对象中的 SQL 文本不加改变地传递到后端。
Jet OLEDB:Partial Bulk Ops (DBPROP_JETOLEDB_BULKPARTIAL)	指示当 SQL DML 操作失败时 Jet 的行为。
Jet OLEDB:Pass Through Query Bulk-Op (DBPROP_JETOLEDB_PASSTHROUGHBULKOP)	指示是否将不返回 Recordset 的查询不加改变地传递给数据源。
Jet OLEDB:Pass Through Query Connect String (DBPROP_JETOLEDB_ODBCPASSTHROUGHCONNECTSTRING)	指示用于连接到远程数据存储的 Jet 连接字符串。除非 Jet OLEDB:ODBC Pass-Through Statement 为 Ture，否则将忽略此值。
Jet OLEDB:Stored Query (DBPROP_JETOLEDB_STOREDQUERY)	指示是否应该将命令文本解释为存储查询而不是 SQL 命令。
Jet OLEDB:Validate Rules On Set (DBPROP_JETOLEDB_VALIDATEONSET)	指示在设置列数据或向数据库提交更改时是否计算 Jet 验证规则。

学63网U7页ggb网(http://www.xwangye.com)

学63网U7页ggb网(http://www.xwangye.com)

默认情况下，OLE DB Provider for Microsoft Jet 以读/写模式打开 Microsoft Jet 数据库。要以只读模式打开数据库，请把 ADO Connection 对象的 Mode 属性设置为 adModeRead。

学63网U7页ggb网(http://www.xwangye.com)

Command 对象的用法

学63网U7页ggb网(http://www.xwangye.com)

Command 对象中的命令文本使用 Microsoft Jet SQL 方言。可以在命令文本中指定行返回查询、操作查询和表名，但存储过程将不受支持也不能指定。

学63网U7页ggb网(http://www.xwangye.com)

Recordset 行为

学63网U7页ggb网(http://www.xwangye.com)

Microsoft Jet 数据库引擎不支持动态游标。因此，OLE DB Provider for Microsoft Jet 不支持 adLockDynamic 游标类型。请求动态游标时，提供者将返回一个键集游标并重置 CursorType 属性以指示返回的 Recordset 的类型。另外，如果请求可更新的 Recordset（LockType 为 adLockOptimistic、adLockBatchOptimistic 或 adLockPessimistic），提供者也将返回一个键集游标并重置 CursorType 属性。

学63网U7页ggb网(http://www.xwangye.com)

动态属性

学63网U7页ggb网(http://www.xwangye.com)

OLE DB Provider for Microsoft Jet 向未打开的 Connection、Recordset 和 Command 对象的 Properties 集合中插入了多个动态属性。

学63网U7页ggb网(http://www.xwangye.com)

下表是每个动态属性的 ADO 和 OLE DB 名称的交*索引。OLE DB Programmer's Reference 使用“Description”项引用 ADO 属性名称。有关这些属性的详细信息，请参阅 OLE DB Programmer's Reference。请在“索引”中搜索 OLE DB 属性名称或参阅 Appendix C:OLE DB Properties。

学63网U7页ggb网(http://www.xwangye.com)

Connection 动态属性

学63网U7页ggb网(http://www.xwangye.com)

下列属性被添加到 Connection 对象的 Properties 集合中。

学63网U7页ggb网(http://www.xwangye.com)

ADO 属性名称	OLE DB 属性名称
Active Sessions	DBPROP_ACTIVESESSIONS
Asynchable Abort	DBPROP_ASYNCTXNABORT
Asynchable Commit	DBPROP_ASYNCTNXCOMMIT
Autocommit Isolation Levels	DBPROP_SESS_AUTOCOMMITISOLEVELS
Catalog Location	DBPROP_CATALOGLOCATION
Catalog Term	DBPROP_CATALOGTERM
Column Definition	DBPROP_COLUMNDEFINITION
Current Catalog	DBPROP_CURRENTCATALOG
Data Source	DBPROP_INIT_DATASOURCE
Data Source Name	DBPROP_DATASOURCENAME
Data Source Object Threading Model	DBPROP_DSOTHREADMODEL
DBMS Name	DBPROP_DBMSNAME
DBMS Version	DBPROP_DBMSVER
GROUP BY Support	DBPROP_GROUPBY
Heterogeneous Table Support	DBPROP_HETEROGENEOUSTABLES
Identifier Case Sensitivity	DBPROP_IDENTIFIERCASE
Isolation Levels	DBPROP_SUPPORTEDTXNISOLEVELS
Isolation Retention	DBPROP_SUPPORTEDTXNISORETAIN
Locale Identifier	DBPROP_INIT_LCID
Maximum Index Size	DBPROP_MAXINDEXSIZE
Maximum Row Size	DBPROP_MAXROWSIZE
Maximum Row Size Includes BLOB	DBPROP_MAXROWSIZEINCLUDESBLOB
Maximum Tables in SELECT	DBPROP_MAXTABLESINSELECT
Mode	DBPROP_INIT_MODE
Multiple Parameter Sets	DBPROP_MULTIPLEPARAMSETS
Multiple Results	DBPROP_MULTIPLERESULTS
Multiple Storage Objects	DBPROP_MULTIPLESTORAGEOBJECTS
Multi-Table Update	DBPROP_MULTITABLEUPDATE
NULL Collation Order	DBPROP_NULLCOLLATION
NULL Concatenation Behavior	DBPROP_CONCATNULLBEHAVIOR
OLE DB Version	DBPROP_PROVIDEROLEDBVER
OLE Object Support	DBPROP_OLEOBJECTS
Open Rowset Support	DBPROP_OPENROWSETSUPPORT
ORDER BY Columns in Select List	DBPROP_ORDERBYCOLUMNSINSELECT
Output Parameter Availability	DBPROP_OUTPUTPARAMETERAVAILABILITY
Pass By Ref Accessors	DBPROP_BYREFACCESSORS
Password	DBPROP_AUTH_PASSWORD
Persistent ID Type	DBPROP_PERSISTENTIDTYPE
Prepare Abort Behavior	DBPROP_PREPAREABORTBEHAVIOR
Prepare Commit Behavior	DBPROP_PREPARECOMMITBEHAVIOR
Procedure Term	DBPROP_PROCEDURETERM
Prompt	DBPROP_INIT_PROMPT
Provider Friendly Name	DBPROP_PROVIDERFRIENDLYNAME
Provider Name	DBPROP_PROVIDERFILENAME
Provider Version	DBPROP_PROVIDERVER
Read-Only Data Source	DBPROP_DATASOURCEREADONLY
Rowset Conversions on Command	DBPROP_ROWSETCONVERSIONSONCOMMAND
Schema Term	DBPROP_SCHEMATERM
Schema Usage	DBPROP_SCHEMAUSAGE
SQL Support	DBPROP_SQLSUPPORT
Structured Storage	DBPROP_STRUCTUREDSTORAGE
Subquery Support	DBPROP_SUBQUERIES
Table Term	DBPROP_TABLETERM
Transaction DDL	DBPROP_SUPPORTEDTXNDDL
User ID	DBPROP_AUTH_USERID
User Name	DBPROP_USERNAME
Window Handle	DBPROP_INIT_HWND

学63网U7页ggb网(http://www.xwangye.com)

学63网U7页ggb网(http://www.xwangye.com)

Recordset 动态属性

学63网U7页ggb网(http://www.xwangye.com)

下列属性被添加到 Recordset 对象的 Properties 集合中。

学63网U7页ggb网(http://www.xwangye.com)

ADO 属性名称	OLE DB 属性名称
Access Order	DBPROP_ACCESSORDER
Append-Only Rowset	DBPROP_APPENDONLY
Blocking Storage Objects	DBPROP_BLOCKINGSTORAGEOBJECTS
Bookmark Type	DBPROP_BOOKMARKTYPE
Bookmarkable	DBPROP_IROWSETLOCATE
Bookmarks Ordered	DBPROP_ORDEREDBOOKMARKS
Cache Deferred Columns	DBPROP_CACHEDEFERRED
Change Inserted Rows	DBPROP_CHANGEINSERTEDROWS
Column Privileges	DBPROP_COLUMNRESTRICT
Column Set Notification	DBPROP_NOTIFYCOLUMNSET
Column Writable	DBPROP_MAYWRITECOLUMN
Defer Column	DBPROP_DEFERRED
Delay Storage Object Updates	DBPROP_DELAYSTORAGEOBJECTS
Fetch Backwards	DBPROP_CANFETCHBACKWARDS
Hold Rows	DBPROP_CANHOLDROWS
IAccessor	DBPROP_IAccessor
IColumnsInfo	DBPROP_IColumnsInfo
IColumnsRowset	DBPROP_IColumnsRowset
IConnectionPointContainer	DBPROP_IConnectionPointContainer
IConvertType	DBPROP_IConvertType
ILockBytes	DBPROP_ILockBytes
Immobile Rows	DBPROP_IMMOBILEROWS
IRowset	DBPROP_IRowset
IRowsetChange	DBPROP_IRowsetChange
IRowsetIdentity	DBPROP_IRowsetIdentity
IRowsetIndex	DBPROP_IRowsetIndex
IRowsetInfo	DBPROP_IRowsetInfo
IRowsetLocate	DBPROP_IRowsestLocate
IRowsetResynch
IRowsetScroll	DBPROP_IRowsetScroll
IRowsetUpdate	DBPROP_IRowsetUpdate
ISequentialStream	DBPROP_ISequentialStream
IStorage	DBPROP_IStorage
IStream	DBPROP_IStream
ISupportErrorInfo	DBPROP_ISupportErrorInfo
Literal Bookmarks	DBPROP_LITERALBOOKMARKS
Literal Row Identity	DBPROP_LITERALIDENTITY
Maximum Open Rows	DBPROP_MAXOPENROWS
Maximum Pending Rows	DBPROP_MAXPENDINGROWS
Maximum Rows	DBPROP_MAXROWS
Memory Usage	DBPROP_MEMORYUSAGE
Notification Granularity	DBPROP_NOTIFICATIONGRANULARITY
Notification Phases	DBPROP_NOTIFICATIONPHASES
Objects Transacted	DBPROP_TRANSACTEDOBJECT
Others' Changes Visible	DBPROP_OTHERUPDATEDELETE
Others' Inserts Visible	DBPROP_OTHERINSERT
Own Changes Visible	DBPROP_OWNUPDATEDELETE
Own Inserts Visible	DBPROP_OWNINSERT
Preserve on Abort	DBPROP_ABORTPRESERVE
Preserve on Commit	DBPROP_COMMITPRESERVE
Quick Restart	DBPROP_QUICKRESTART
Reentrant Events	DBPROP_REENTRANTEVENTS
Remove Deleted Rows	DBPROP_REMOVEDELETED
Report Multiple Changes	DBPROP_REPORTMULTIPLECHANGES
Return Pending Inserts	DBPROP_RETURNPENDINGINSERTS
Row Delete Notification	DBPROP_NOTIFYROWDELETE
Row First Change Notification	DBPROP_NOTIFYROWFIRSTCHANGE
Row Insert Notification	DBPROP_NOTIFYROWINSERT
Row Privileges	DBPROP_ROWRESTRICT
Row Resynchronization Notification	DBPROP_NOTIFYROWRESYNCH
Row Threading Model	DBPROP_ROWTHREADMODEL
Row Undo Change Notification	DBPROP_NOTIFYROWUNDOCHANGE
Row Undo Delete Notification	DBPROP_NOTIFYROWUNDODELETE
Row Undo Insert Notification	DBPROP_NOTIFYROWUNDOINSERT
Row Update Notification	DBPROP_NOTIFYROWUPDATE
Rowset Fetch Position Change Notification	DBPROP_NOTIFYROWSETFETCHPOSISIONCHANGE
Rowset Release Notification	DBPROP_NOTIFYROWSETRELEASE
Scroll Backwards	DBPROP_CANSCROLLBACKWARDS
Skip Deleted Bookmarks	DBPROP_BOOKMARKSKIPPED
Strong Row Identity	DBPROP_STRONGITDENTITY
Updatability	DBPROP_UPDATABILITY
Use Bookmarks	DBPROP_BOOKMARKS

学63网U7页ggb网(http://www.xwangye.com)

学63网U7页ggb网(http://www.xwangye.com)

Command 动态属性

学63网U7页ggb网(http://www.xwangye.com)

下列属性被添加到 Command 对象的 Properties 集合中。

学63网U7页ggb网(http://www.xwangye.com)

ADO 属性名称	OLE DB 属性名称
Access Order	DBPROP_ACCESSORDER
Append-Only Rowset	DBPROP_APPENDONLY
Blocking Storage Objects	DBPROP_BLOCKINGSTORAGEOBJECTS
Bookmark Type	DBPROP_BOOKMARKTYPE
Bookmarkable	DBPROP_IROWSETLOCATE
Change Inserted Rows	DBPROP_CHANGEINSERTEDROWS
Column Privileges	DBPROP_COLUMNRESTRICT
Column Set Notification	DBPROP_NOTIFYCOLUMNSET
Defer Column	DBPROP_DEFERRED
Delay Storage Object Updates	DBPROP_DELAYSTORAGEOBJECTS
Fetch Backwards	DBPROP_CANFETCHBACKWARDS
Hold Rows	DBPROP_CANHOLDROWS
IAccessor	DBPROP_IAccessor
IColumnsInfo	DBPROP_IColumnsInfo
IColumnsRowset	DBPROP_IColumnsRowset
IConnectionPointContainer	DBPROP_IConnectionPointContainer
IConvertType	DBPROP_IConvertType
ILockBytes	DBPROP_ILockBytes
Immobile Rows	DBPROP_IMMOBILEROWS
IRowset	DBPROP_IRowset
IRowsetChange	DBPROP_IRowsetChange
IRowsetIdentity	DBPROP_IRowsetIdentity
IRowsetIndex	DBPROP_IRowsetIndex
IRowsetInfo	DBPROP_IRowsetInfo
IRowsetLocate	DBPROP_IRowsetLocate
IRowsetResynch
IRowsetScroll	DBPROP_IRowsetScroll
IRowsetUpdate	DBPROP_IRowsetUpdate
ISequentialStream	DBPROP_ISequentialStream
IStorage	DBPROP_IStorage
IStream	DBPROP_IStream
ISupportErrorInfo	DBPROP_ISupportErrorInfo
Literal Bookmarks	DBPROP_LITERALBOOKMARKS
Literal Row Identity	DBPROP_LITERALIDENTITY
Lock Mode	DBPROP_LOCKMODE
Maximum Open Rows	DBPROP_MAXOPENROWS
Maximum Pending Rows	DBPROP_MAXPENDINGROWS
Maximum Rows	DBPROP_MAXROWS
Notification Granularity	DBPROP_NOTIFICATIONGRANULARITY
Notification Phases	DBPROP_NOTIFICATIONPHASES
Objects Transacted	DBPROP_TRANSACTEDOBJECT
Others' Changes Visible	DBPROP_OTHERUPDATEDELETE
Others' Inserts Visible	DBPROP_OTHERINSERT
Own Changes Visible	DBPROP_OWNUPDATEDELETE
Own Inserts Visible	DBPROP_OWNINSERT
Preserve on Abort	DBPROP_ABORTPRESERVE
Preserve on Commit	DBPROP_COMMITPRESERVE
Quick Restart	DBPROP_QUICKRESTART
Reentrant Events	DBPROP_REENTRANTEVENTS
Remove Deleted Rows	DBPROP_REMOVEDELETED
Report Multiple Changes	DBPROP_REPORTMULTIPLECHANGES
Return Pending Inserts	DBPROP_RETURNPENDINGINSERTS
Row Delete Notification	DBPROP_NOTIFYROWDELETE
Row First Change Notification	DBPROP_NOTIFYROWFIRSTCHANGE
Row Insert Notification	DBPROP_NOTIFYROWINSERT
Row Privileges	DBPROP_ROWRESTRICT
Row Resynchronization Notification	DBPROP_NOTIFYROWRESYNCH
Row Threading Model	DBPROP_ROWTHREADMODEL
Row Undo Change Notification	DBPROP_NOTIFYROWUNDOCHANGE
Row Undo Delete Notification	DBPROP_NOTIFYROWUNDODELETE
Row Undo Insert Notification	DBPROP_NOTIFYROWUNDOINSERT
Row Update Notification	DBPROP_NOTIFYROWUPDATE
Rowset Fetch Position Change Notification	DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE
Rowset Release Notification	DBPROP_NOTIFYROWSETRELEASE
Scroll Backwards	DBPROP_CANSCROLLBACKWARDS
Server Data on Insert	DBPROP_SERVERDATAONINSERT
Skip Deleted Bookmarks	DBPROP_BOOKMARKSKIP
Strong Row Identity	DBPROP_STRONGIDENTITY
Updatability	DBPROP_UPDATABILITY
Use Bookmarks	DBPROP_BOOKMARKS

学63网U7页ggb网(http://www.xwangye.com)

学63网U7页ggb网(http://www.xwangye.com)

请参阅   有关 OLE DB Provider for Microsoft Jet 的特定实现和功能的详细信息，请参阅 MDAC SDK 中的 OLE DB Provider for Microsoft Jet 文档。

学63网U7页ggb网(http://www.xwangye.com)