Microsoft KB Archive/96892

= ACC: Page Locking, No Cluster Indexing Support =

Article ID: 96892

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96892



SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser *skills.

Cluster indexing and row-level locking are not possible with Microsoft Access, unless you are using a linked (attached) table.



MORE INFORMATION
These features are not supported because of the variable-length architecture. When using a linked table, Microsoft Access uses the same locking scheme as the native product. When you use the installable ISAMs for dBASE, Paradox, and Btrieve, you do record- level locking. The Paradox ISAM even understands clustered indexes and takes advantage of these indexes in some queries.

NOTE: The Btrieve ISAM driver applies only to Microsoft Access 1.x and 2.0.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Keywords: kb3rdparty kbinfo KB96892

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.