防止锁定MS Access数据库表 [英] Prevent Locking in MS Access Database Table

问题描述

你好

如何防止MS Access数据库表中的锁定?


谢谢
lakshman

Hello

How to Prevent Locking in MS Access Database Table?


Thanks
lakshman

推荐答案

如果您在Access中进行此操作，则Forms，Reports和Queries具有一个RecordLocks属性，该属性控制如何锁定基础数据.
将此设置为无锁定"(0)意味着将使用开放式锁定，并且两个或更多用户可以编辑记录.

如果在访问代码中使用DAO，则LockEdits属性具有相似的效果，当设置为True时，将使用悲观锁定.设置为false时，将进行优化锁定-在执行Update方法之前，页面不会被锁定.

If you''re doing this within Access, Forms, Reports and Queries have a RecordLocks property that controls how the underlying data is locked.

Setting this to "No Locks" (0) should mean that optimistic locking is used, and two or more users can edit the record.

If using DAO in Access Code, then the LockEdits property has a similar effect, when set to True, pessimistic locking is used. When set to false, optimisitic locking - the page is not locked until the Update method is excuted.

这篇关于防止锁定MS Access数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！