ACC: Page Locking, No Cluster Indexing Support (96892)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kb3rdparty kbinfo KB96892
©2002 Microsoft Corporation. All rights reserved.