Multiuser Locking

Microsoft® Access offers two levels of locking: locked or unlocked. It uses the operating system to lock portions of the data to allow two or more users to have simultaneous locks to different areas of the file. However, the Access default is to open the .mdb file for exclusive use. In contrast, Microsoft SQL Server™ expects many simultaneous users and has more sophisticated locking strategies.

See Also

Locking

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.