ACC: Page Locking, No Cluster Indexing Support

ID: Q96892

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

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 GnlMu 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: March 20, 1999